Skip to Content
0
Former Member
May 02, 2018 at 05:16 PM

SDA Create Virtual table on HIVE table with PARQUET format gives JDB[257] Error

224 Views

Hi,

We're using HADOOP(ODBC) to create SDA connection with HIVE. Connection is working fine and able to see all tables defined on HIVE schema. I'm getting below error when tried to create a virtual table on HIVE table defined with PARQUET format. It is working fine for table created with TEXT format.

SAP DBtech JDBC: [257]: sql syntax error: incorrect syntax near """; Line 1 col 942 (at pos 942)

Is PARQUET table format supported in HANA SDA? Is there a way I can see the SQL generated for CREATE VIRTUAL TABLE? How can it be fixed?

Thanks,

Milind