Ask Your Question
0

I have error reading query from JDBC query consumer

asked 2020-05-27 17:08:26 -0500

anonymous user

Anonymous

updated 2021-01-13 11:25:08 -0500

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

edit retag flag offensive close merge delete

Comments

What does your query look like?

iamontheinet gravatar imageiamontheinet ( 2020-05-27 23:52:31 -0500 )edit

hi @iamontheinet thanks for looking into it. attached query in question.

strem_dev gravatar imagestrem_dev ( 2020-05-28 08:43:20 -0500 )edit

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.

Jarcec gravatar imageJarcec ( 2020-05-29 16:35:59 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
1

answered 2020-05-29 16:50:05 -0500

strem_dev gravatar image

i'm using jdbc origin and issue i had was hive not supporting time_stamp function(impala does). i have changed my query now its working fine. yes in hive we can use with its wrking fine fr me :)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-05-27 17:08:26 -0500

Seen: 904 times

Last updated: Jan 13