Created on 03-13-2019 04:29 AM - edited 03-13-2019 05:04 AM
Hello,
I have an issue with running query on SAP Hana db, in the $conditions I need column name to be eclosed by double quotes because I get the error: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ...
Query should be like this:
SELECT "COL1", "COL2"
FROM "SAPSR3"."TABLEVIEW"
WHERE "CONDCOL">=2011 AND "CONDCOL"<=2011
When I run the query without --slpit-by option it works.
Is there any way to modify the way query is generated?
Also it will be very usefull to see the generated query by Sqoop.
I use Sqoop 1.4.7 and ngdbc-2.3.56.jar for connection.
Thank you,
Catalin
Created 03-14-2019 12:39 AM
Created 03-14-2019 01:57 AM
Hello Harsh,
I am using --verbose but i get no queries:
also I am using --boundary-query but I have to provide --split-by column so it is not working.
Created 03-15-2019 03:57 AM
Hi,
Can you please upload the full Sqoop command and the console level logs so we can test it out.
Regards
Nitish