org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:32 cannot recognize input near '(' 'DAYOFYEAR_KEY' ',' in statement

Oracle Community | 945aadfe-206a-4e98-83f9-77707279102f | 2 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Unable to Load Data from Oracle table to hive partitioned table using ODI

    Oracle Community | 2 years ago | 945aadfe-206a-4e98-83f9-77707279102f
    org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:32 cannot recognize input near '(' 'DAYOFYEAR_KEY' ',' in statement

    Root Cause Analysis

    1. org.apache.hive.service.cli.HiveSQLException

      Error while compiling statement: FAILED: ParseException line 1:32 cannot recognize input near '(' 'DAYOFYEAR_KEY' ',' in statement

      at org.apache.hive.jdbc.Utils.verifySuccess()
    2. org.apache.hive
      Utils.verifySuccessWithInfo
      1. org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:231)
      2. org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:217)
      2 frames