I have error reading query from JDBC query consumer
Hi All, i have query which is running fine in hive/hue and i'm using jdbc consumer origin and it's throwing an error. can plz let me know if some had similar issue. Thank you.
Error: SQLState: HY000 Error Code: 500051 Message: [Cloudera][HiveJDBCDriver](500051) ERROR processing query/statement. Error Code: 40000, SQL state: TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: ParseException line 10:12 mismatched input 'as' expecting ) near '0' in from source:28:27,
Deleted Query here
What does your query look like?
hi @iamontheinet thanks for looking into it. attached query in question.
Are you sure that is the whole query configured in StreamSet's origin @strem_dev? Or that this precise blurb is a valid query? I have to say that I don't recall Hive supporting queries that start with "with" keyword.