This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am not able to create a new table in HIVE or transfer data from SQL server to HIVE. I am getting the following error :
Error: Output Data (2): DataWrap2ODBC::SendBatch: [Hortonworks][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: ParseException line 1:86 cannot recognize input near '?' ',' '?' in expression specification Insert into `cn_ec_mrm_dl_secure`.`test1_0`(`table_name`,`last_updated_date`) Values (?,?)
Whereas there is no input as `?` or `,`. I am just executing a simple query like select * from tablename and trying to output the and save results in HIVE.
HIVE driver used is Hortonworks Hive ODBC driver .