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 | 2 months ago
  1. 0

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

    hortonworks.com | 2 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 | 10 months 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 | 5 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)
  6. 0

    SparkSQL does not work with Hive UDAF

    Stack Overflow | 7 months ago | H. Wang
    org.apache.hadoop.hive.ql.parse.SemanticException: Line 16:32 Invalid column reference 'C'

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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