Can i create a new column using jdbc query consumer ?

asked 2020-04-07 13:54:39 -0500

anonymous user

Anonymous

updated 2020-04-08 19:15:14 -0500

metadaddy gravatar image

Can i use this query ?

select row_number() over (partition by product_id order by report_dt,product_id desc ) as review_id from DBname.tablename

This query is working fine in Hive but not working in StreamSets JDBC .

SS jdbc query consumer log_info:

HikariPool-26 - Driver does not support get/set network timeout for connections. (com.cloudera.hiveserver2.jdbc.jdbc4.S4Connection.getNetworkTimeout()I)

Do we need drivers or anything related to hikaripool to build column ?

Please let us know if any specific drivers needed to run this query!

edit retag flag offensive close merge delete

Comments

strem_dev gravatar imagestrem_dev ( 2020-04-07 14:27:37 -0500 )edit

Can you post the full stack trace from sdc.log? Is it just this particular query that fails?

metadaddy gravatar imagemetadaddy ( 2020-04-08 19:17:55 -0500 )edit