java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Error while processing statement: FAILED: SemanticException [Error 10004]: Line 10:100 Invalid table alias or column reference 'FACT': (possible column names are: c0, c1)

Pentaho BI Platform Tracking | Mauro Patroni | 3 years ago
  1. 0

    if the datasource is builded with "SQL statement" while the analysis the query passed to HIVE is wrong because HIVE in "order by" clause (and so on) want the alias fields declared up in fields list, this is the query formed and error: select FACT.description_s07 as c0, FACT.description_s08 as c1 from (SELECT s07.total_emp as total_emp_s07, s07.description as description_s07, s07.salary as salary_s07, s08.total_emp as total_emp_s08, s08.description as description_s08, s08.salary as salary_s08 FROM sample_07 s07 JOIN sample_08 s08 ON ( s07.code = s08.code)) FACT group by FACT.description_s07, FACT.description_s08 order by ISNULL(FACT.description_s07) ASC, FACT.description_s07 ASC, ISNULL(FACT.description_s08) ASC, FACT.description_s08 ASC E Hive gli rerstituisce: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Error while processing statement: FAILED: SemanticException [Error 10004]: Line 10:100 Invalid table alias or column reference 'FACT': (possible column names are: c0, c1) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:213) at com.pentaho.analyzer.content.controller.j.a(SourceFile:170)

    Pentaho BI Platform Tracking | 3 years ago | Mauro Patroni
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Error while processing statement: FAILED: SemanticException [Error 10004]: Line 10:100 Invalid table alias or column reference 'FACT': (possible column names are: c0, c1)
  2. 0

    if the datasource is builded with "SQL statement" while the analysis the query passed to HIVE is wrong because HIVE in "order by" clause (and so on) want the alias fields declared up in fields list, this is the query formed and error: select FACT.description_s07 as c0, FACT.description_s08 as c1 from (SELECT s07.total_emp as total_emp_s07, s07.description as description_s07, s07.salary as salary_s07, s08.total_emp as total_emp_s08, s08.description as description_s08, s08.salary as salary_s08 FROM sample_07 s07 JOIN sample_08 s08 ON ( s07.code = s08.code)) FACT group by FACT.description_s07, FACT.description_s08 order by ISNULL(FACT.description_s07) ASC, FACT.description_s07 ASC, ISNULL(FACT.description_s08) ASC, FACT.description_s08 ASC E Hive gli rerstituisce: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Error while processing statement: FAILED: SemanticException [Error 10004]: Line 10:100 Invalid table alias or column reference 'FACT': (possible column names are: c0, c1) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:213) at com.pentaho.analyzer.content.controller.j.a(SourceFile:170)

    Pentaho BI Platform Tracking | 3 years ago | Mauro Patroni
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Error while processing statement: FAILED: SemanticException [Error 10004]: Line 10:100 Invalid table alias or column reference 'FACT': (possible column names are: c0, c1)
  3. 0

    Drools Fusion: Problem with @Duration property.

    Google Groups | 4 months ago | Stu R
    java.lang.RuntimeException: Error while creating KieBase[Message [id=1, level=ERROR, path=null, line=-1, column=0 text=Error processing @duration for TypeDeclaration 'com.sample.Instance': cannot access the field 'durationTime']]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Drools Fusion: Problem with @Duration property.

    Google Groups | 4 months ago | Stu R
    java.lang.RuntimeException: Error while creating KieBase[Message [id=1, level=ERROR, path=null, line=-1, column=0 text=Error processing @duration for TypeDeclaration 'com.sample.Instance': cannot access the field 'durationTime']]
  6. 0

    Drools Error when using 'or' with sister classes

    Stack Overflow | 3 months ago | Hangman4358
    java.lang.RuntimeException: Error while creating KieBase[Message [id=1, level=ERROR, path=Sample.drl, line=12, column=0 text=Duplicate declaration for variable 'f' in the rule 'Rule 1'], Message [id=2, level=ERROR, path=Sample.drl, line=10, column=0 text=Unable to Analyse Expression System.out.println(f);: [Error: unable to resolve method using strict-mode: org.drools.core.spi.KnowledgeHelper.f()] [Near : {... System.out.println(f); ....}] ^ [Line: 10, Column: 0]]]

    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. java.lang.RuntimeException

      java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Error while processing statement: FAILED: SemanticException [Error 10004]: Line 10:100 Invalid table alias or column reference 'FACT': (possible column names are: c0, c1)

      at com.pentaho.analyzer.report.ReportRequestService.get()
    2. com.pentaho.analyzer
      j.a
      1. com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:213)
      2. com.pentaho.analyzer.content.controller.j.a(SourceFile:170)
      2 frames