1 2 Previous Next 15 Replies Latest reply on Jun 16, 2017 5:04 PM by virtualdatabase

    Native Query for Hive/Hortonworks

    virtualdatabase Apprentice

      While trying to get more metdata information for our Hortonworks I have created a physical table with native query as "Show Tables" with one column tab_name

      WHen I deploy and run select * from this physical table it errors with:

       

      Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ResearchLakeTesting: 40000 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.tab_name AS c_0 FROM (show tables) g_0 LIMIT 100]

      SQLState:  50000

      ErrorCode: 30504

       

      So I can see that the native query is wrapped  by the select statement.

       

      Any suggestions on how to make this work ?


      BTW.. .a jdbc connection straight to the hortonworks with Squirrel allows me to just type "Show Tables" at a SQL prompt and it runs

       

       

       

      Additionally I would be doing something similar using "describe extended  <tableName>

      which also returns a resultset"

       

      col_namestring
      data_typestring
      commentstring

       

       

      Thanks in advance for any suggestions/help

        1 2 Previous Next