Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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,

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,

#

with last_month as ( select max(dt) max_dt from app_annie_raw.appl_details where dt between months_add(now(),-12) and now() ), month_pool as ( select add_months(max_dt,zz.n) as dt from (VALUES(0 as n),(-1),(-2),(-3),(-4),(-5),(-6),(-7),(-8),(-9),(-10),(-11)) zz join last_month on 1=1 ) select market , product_id , FROM_TIMESTAMP(mp.dt,'yyyy-MM-dd') as start_date , FROM_TIMESTAMP(last_day(mp.dt),'yyyy-MM-dd') as end_date from ( select product_id , market , max( nvl(case when v.dt<lm.max_dt then="" dt="" end,="" months_add(lm.max_dt,-12)))="" as="" min_dt="" ,="" lm.max_dt="" as="" max_dt="" ,="" max(case="" when="" v.dt="lm.max_dt" then="" 1="" else="" 0="" end)="" as="" is_current="" from="" app_annie_raw.appl_details="" v="" join="" last_month="" lm="" on="" v.dt="" between="" months_add(max_dt,-12)="" and="" max_dt="" group="" by="" product_id,="" market,="" lm.max_dt="" )="" a="" join="" month_pool="" mp="" on="" mp.dt="" between="" add_months(a.min_dt,1)="" and="" a.max_dt="" where="" is_current="1&lt;/p">

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,

#

with last_month as ( select max(dt) max_dt from app_annie_raw.appl_details app_raw.details where dt between months_add(now(),-12) and now() ), month_pool as ( select add_months(max_dt,zz.n) as dt from (VALUES(0 as n),(-1),(-2),(-3),(-4),(-5),(-6),(-7),(-8),(-9),(-10),(-11)) zz join last_month on 1=1 ) select market , product_id , FROM_TIMESTAMP(mp.dt,'yyyy-MM-dd') as start_date , FROM_TIMESTAMP(last_day(mp.dt),'yyyy-MM-dd') as end_date from ( select product_id , market , max( nvl(case when v.dt<lm.max_dt then="" dt="" end,="" months_add(lm.max_dt,-12)))="" as="" min_dt="" ,="" lm.max_dt="" as="" max_dt="" ,="" max(case="" when="" v.dt="lm.max_dt" then="" 1="" else="" 0="" end)="" as="" is_current="" from="" app_annie_raw.appl_details="" app_raw.details="" v="" join="" last_month="" lm="" on="" v.dt="" between="" months_add(max_dt,-12)="" and="" max_dt="" group="" by="" product_id,="" market,="" lm.max_dt="" )="" a="" join="" month_pool="" mp="" on="" mp.dt="" between="" add_months(a.min_dt,1)="" and="" a.max_dt="" where="" is_current="1&lt;/p">

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,

#

with last_month as ( select max(dt) max_dt from app_raw.details a where dt between months_add(now(),-12) and now() ), month_pool as ( select add_months(max_dt,zz.n) as dt from (VALUES(0 as n),(-1),(-2),(-3),(-4),(-5),(-6),(-7),(-8),(-9),(-10),(-11)) zz join last_month on 1=1 ) select market , product_id , FROM_TIMESTAMP(mp.dt,'yyyy-MM-dd') as start_date , FROM_TIMESTAMP(last_day(mp.dt),'yyyy-MM-dd') as end_date from ( select product_id , market , max( nvl(case when v.dt<lm.max_dt then="" dt="" end,="" months_add(lm.max_dt,-12)))="" as="" min_dt="" ,="" lm.max_dt="" as="" max_dt="" ,="" max(case="" when="" v.dt="lm.max_dt" then="" 1="" else="" 0="" end)="" as="" is_current="" from="" app_raw.details="" a="" v="" join="" last_month="" lm="" on="" v.dt="" between="" months_add(max_dt,-12)="" and="" max_dt="" group="" by="" product_id,="" market,="" lm.max_dt="" )="" a="" join="" month_pool="" mp="" on="" mp.dt="" between="" add_months(a.min_dt,1)="" and="" a.max_dt="" where="" is_current="1&lt;/p">

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

with last_month as ( select max(dt) max_dt from a where dt between months_add(now(),-12) and now() ), month_pool as ( select add_months(max_dt,zz.n) as dt from (VALUES(0 as n),(-1),(-2),(-3),(-4),(-5),(-6),(-7),(-8),(-9),(-10),(-11)) zz join last_month on 1=1 ) select market , product_id , FROM_TIMESTAMP(mp.dt,'yyyy-MM-dd') as start_date , FROM_TIMESTAMP(last_day(mp.dt),'yyyy-MM-dd') as end_date from ( select product_id , market , max( nvl(case when v.dt<lm.max_dt then="" dt="" end,="" months_add(lm.max_dt,-12)))="" as="" min_dt="" ,="" lm.max_dt="" as="" max_dt="" ,="" max(case="" when="" v.dt="lm.max_dt" then="" 1="" else="" 0="" end)="" as="" is_current="" from="" a="" v="" join="" last_month="" lm="" on="" v.dt="" between="" months_add(max_dt,-12)="" and="" max_dt="" group="" by="" product_id,="" market,="" lm.max_dt="" )="" a="" join="" month_pool="" mp="" on="" mp.dt="" between="" add_months(a.min_dt,1)="" and="" a.max_dt="" where="" is_current="1&lt;/p">