Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I'm trying to extract the data I've in Hive to Qlikview. For that I create a ODBC connection. In script when I access to Hive I can see my table there, however when I load the script it gives me 0 rows... And I've data into Hive...
There's my script:
ODBC CONNECT TO Hive_Table;
SQL SELECT "ID",
"Cover"
FROM HIVE."default"."id";
Anyone knows a possible cause of this problem??
Many thanks!
Hi,
Did you try to delete the quotes?
ODBC CONNECT TO Hive_Table;
SQL SELECT ID,
Cover
FROM HIVE.default.id;
Other thing, do you have a User Name for authentication?
Regards,
Jose