I think you need to try using HiveServer or a JDBC client.
________________________________ From: David Lerman <[email protected]> Reply-To: <[email protected]> Date: Sun, 28 Jun 2009 09:07:22 -0700 To: <[email protected]> Subject: getting the field types of a query result I'm trying to build a tool which runs a query and writes the results into an automatically generated Hive table. It's all very straightforward, except that I can't find a good way to determine the type of the results in order to create the table. For example, if someone runs "select intField, stringField, sum(intField) from ...", I'd like to automatically create a Hive table with an int column, a string column, and an int column and then do a load into that table. Driver.getSchema looks promising but returns strings for all three columns ("struct result { string intField, string stringField, string _c2}"). Any suggestions? Thanks!
