Skip to Content
0

SAP SDA-Hive remote source just fine, but tables not showing up under databases

Dec 12, 2016 at 07:47 PM

114

avatar image
Former Member

Hi experts,

I came all the way here and now I just realized my remote source does not show any tables under my HIVE node. as you can see here there are two databases, default and a custom "MY_HIVE". both have tables. If I expand the node my tables don't show up.

my DSN works just fine. I tested with isql and i can SQL back and forth Default and My_Hive databases.

isql-dump.txt

my-hive-odbc.txt

Just wondering if I am missing something over here, like authorzaiton some sort (I am using SYSTEM here), or maybe the ODBCs drivers are not ok: I dont believe that because i can Isql it just fine.

anyways, any help much appreciated.

Thanks,

Fernando

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Dec 13, 2016 at 01:53 PM
0

this is my own reply: it seems there's a glitch in my SAP HANA Studio installation somehow. It's just not showing the tables under my HIVE schema, but it works!

I was able to create my virtual tables running SQL script:

CREATE VIRTUAL TABLE "LIVE2"."VT_MY_HIVE_wordcount" AT "MY_HIVE"."HIVE"."my_hive"."wordcount";

Statement 'CREATE VIRTUAL TABLE "LIVE2"."VT_MY_HIVE_wordcount" AT "MY_HIVE"."HIVE"."my_hive"."wordcount"' successfully executed in 3.473 seconds (server processing time: 3.415 seconds) - Rows Affected: 0



Create Virtual Tables SQL Scripts - SAP HELP

so. it seems to be only with HIVE and MSSQL remote sources:

another thread, same issue. SDA in SPS11
I am good :)Thanks,Fernando

Share
10 |10000 characters needed characters left characters exceeded