Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 13, 2016 at 01:53 PM

    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
    Add comment
    10|10000 characters needed characters exceeded