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 | 1 year ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

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

    Oracle Community | 1 year 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