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

[former_member198951]

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

[former_member198951]

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