Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview connecting with Hive - ODBC

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!

1 Reply
Not applicable
Author

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