Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to execute a series of Hive statements in Talend.
Firstly, I need to issue a "use my_db_name" command, so that the next command defaults to that database.
Then I need to issue "show tables", and capture the list of tables.
The problem is, the "use my_db_name" command doesn't change the current database. It stays in the database that the connection specifies. The user has access to other databases, so there's no permissions problem.
Any ideas how I can run Hive commands like "use my_db_name" and "show tables" through Talend?
Answering my own question:
Create a connection with an empty database name (""). Then, the "use my_database_name" command will switch database, and subsequent commands will operate in that database.
Answering my own question:
Create a connection with an empty database name (""). Then, the "use my_database_name" command will switch database, and subsequent commands will operate in that database.