Table Exists - Checking Hive tables

[raghunadhn]

Hi All,

I have a simple usecase where I want to check if a table exists in hive. If table exists, I am running a query. If not, I am creating the table and running the query.

I have defined the Hive DB connection, but I am not able to get the table names (screenshot attached for the same). I already have created the table in Hive and so I think, it should show it. Could some one help me out here.

P.s: I have the Hive connection properly defined and in other transformations, I am able to run queries on these tables.

Thanks in advance,
Raghu

[MattCasters]

The Hive JDBC driver is very limited, you might need a driver update to get it to report on tables and schemas.

[raghunadhn]

Thanks for the reply Matt

I am using Hive thrift server. Could you please provide some more info on the driver update

Thanks,
Raghu

[MattCasters]

Pentaho did a lot of work on the Hive driver, why don't you ask around in the Big Data forum. Don't forget to mention which driver you're using now.

[Sushilgyl]

Hi Matt,

I am facing the following problem from the couple of days. Could you please provide ma a solution for that.

I have configured stable release of PDI 4.3 and hive 0.8.1 with Hadoop 1.0.1 and also i am able to make connection with 'Hadoop Hive' database using spoon. But whenever i tried to retrieve the data from Hive table as 'table input' step then it throws the error messege 'Method not supported'.

[MattCasters]

Please post your question in the Big Data forum. And please don't hijack threads.

[Sushilgyl]

Matt

I had already post in Big Data Forum but didn't get any reply.


Sushil Goyal