hive.executeQuery("query") is for read\write operations. But here you are trying a catalog operation. For the catalog operation, you need to use hive.execute("statement") Refer API documentation here : https://docs.hortonworks.com/HDPDocuments/HDP3/HDP-3.1.0/integrating-hive/content/hive_hivewarehousesession_api_operations.html For your specific case of getting the database list, there is a pre-defined catalog operation hive.showDatabases() BTW, this issue has nothing to do with the ingestion. Please make sure to that the title represents the exact problem.
... View more