Hi, In my company, we are working on creating hadoop-hive connector that allows to run query on hive and import its result ( query result ). Before we run the query on hive, we need to understand what output schema it would generate. Is there anyway to do that using any of hive clients ? (Thrift/JDBC etc) ? If such feature is not available, how difficult is it to implement ?
JDBC API provides such feature. See below for information about oracle db implementation of PreparedStatement.getMetaData() JDBC API. It appears hive does not implement it. We are ok even if it is not implemented in JDBC but available through Thrift client. -- >From Oracle release notes: - PreparedStatement.getMetaData() Method Starting from Oracle Database 11g Release 2 (11.2), JDBC drivers support obtaining the metadata of a SELECT statement without executing the PreparedStatement. This feature works even with the earlier database releases. For more information, please refer to "Interface oracle.jdbc.OraclePreparedStatement". At this link: http://docs.oracle.com/cd/E11882_01/java.112/e16548/whatsnew.htm#JJDBC28019
