org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 1:50 Invalid table alias or column reference 'b': (possible column names are: id, name)

hortonworks.com | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    HPL-SQL : Function creation issues in Hive 2.0 - Hortonworks

    hortonworks.com | 7 months ago
    org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 1:50 Invalid table alias or column reference 'b': (possible column names are: id, name)
  2. 0

    Inconsistent behaviour on different enviroments - Cloudera Community

    cloudera.com | 1 year ago
    org.apache.hadoop.hive.ql.parse.SemanticException: Partition not found day > '0' AND month > '0' AND year > '0' AND fulldate > '0' AND period > '0' AND ymd > '0' at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyze r.addTableDropPartsOutputs(DDLSemanticAnalyzer.jav a:2686) at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyze r.analyzeAlterTableDropParts(DDLSemanticAnalyzer.j ava:2250)
  3. 0

    failed: semanticexception the current builtin authoization in hive is incomplete and disabled

    Stack Overflow | 1 year ago | Jingyu Xu
    org.apache.hadoop.hive.ql.parse.SemanticException: The current builtin authorization in Hive is incomplete and disabled.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Inconsistent behaviour on different enviroments - Cloudera Community

    cloudera.com | 10 months ago
    org.apache.hadoop.hive.ql.parse.SemanticException: Partition not found day > '0' AND month > '0' AND year > '0' AND fulldate > '0' AND period > '0' AND ymd > '0' at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyze r.addTableDropPartsOutputs(DDLSemanticAnalyzer.jav a:2686) at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyze r.analyzeAlterTableDropParts(DDLSemanticAnalyzer.j ava:2250)

    2 unregistered visitors

    Root Cause Analysis

    1. org.apache.hadoop.hive.ql.parse.SemanticException

      Line 1:50 Invalid table alias or column reference 'b': (possible column names are: id, name)

      at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genAllExprNodeDesc()
    2. Hive Query Language
      Driver.compileAndRespond
      1. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genAllExprNodeDesc(SemanticAnalyzer.java:10537)
      2. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:10485)
      3. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genSelectPlan(SemanticAnalyzer.java:3822)
      4. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genSelectPlan(SemanticAnalyzer.java:3601)
      5. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPostGroupByBodyPlan(SemanticAnalyzer.java:8965)
      6. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:8920)
      7. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9765)
      8. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9658)
      9. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genOPTree(SemanticAnalyzer.java:10131)
      10. org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:329)
      11. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10142)
      12. org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:211)
      13. org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:227)
      14. org.apache.hadoop.hive.ql.Driver.compile(Driver.java:459)
      15. org.apache.hadoop.hive.ql.Driver.compile(Driver.java:316)
      16. org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1189)
      17. org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1183)
      17 frames
    3. org.apache.hive
      HiveSessionImpl.executeStatementAsync
      1. org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:110)
      2. org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:181)
      3. org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)
      4. org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:419)
      5. org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:406)
      5 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor110.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:497)
      3 frames
    5. org.apache.hive
      HiveSessionProxy$1.run
      1. org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
      2. org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)
      3. org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
      3 frames
    6. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:422)
      2 frames
    7. Hadoop
      UserGroupInformation.doAs
      1. org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1709)
      1 frame
    8. org.apache.hive
      HiveSessionProxy.invoke
      1. org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
      1 frame
    9. com.sun.proxy
      $Proxy20.executeStatementAsync
      1. com.sun.proxy.$Proxy20.executeStatementAsync(Unknown Source)
      1 frame
    10. org.apache.hive
      TCLIService$Processor$ExecuteStatement.getResult
      1. org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:276)
      2. org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)
      3. org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1317)
      4. org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1302)
      4 frames
    11. Apache Thrift
      TBaseProcessor.process
      1. org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
      2. org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
      2 frames
    12. org.apache.hive
      TSetIpAddressProcessor.process
      1. org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
      1 frame
    13. Apache Thrift
      TThreadPoolServer$WorkerProcess.run
      1. org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)
      1 frame
    14. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      3. java.lang.Thread.run(Thread.java:745)
      3 frames