Hi Mark, Try this link for Hive .5 JDBC driver: http://aws.amazon.com/developertools/Elastic-MapReduce/0196055244487017
We are actually in Seattle office. Best Regards, Peter- From: Sunderlin, Mark [mailto:mark.sunder...@teamaol.com] Sent: Friday, February 18, 2011 6:26 AM To: 'user@hive.apache.org' Subject: RE: Hive Not Returning Column Names, even what not using 'When'?? Hey Peter, this looks like it ought to work for me but .... The link to the hive 0.5 hive drivers ... seems broken??? http://buyitnw.appspot.com/aws.amazon.com/developertools/Elastic-MapReduce/0196055244487017 seems to be the link from the site you mention below, but it returns a blank page? The link to the 0.7 drivers: http://aws.amazon.com/developertools/Elastic-MapReduce/1818074809286277 Seems to work just fine. p.s. Wonder if by chance you work at the Amazon office right down the street from AOL here in N. Va. --- Mark E. Sunderlin Solutions Architect |AOL Data Warehouse P: 703-256-6935 | C: 540-327-6222 AIM: MESunderlin 22000 AOL Way | Dulles, VA | 20166 From: Sirota, Peter [mailto:sir...@amazon.com] Sent: Thursday, February 17, 2011 7:54 PM To: user@hive.apache.org Subject: RE: Hive Not Returning Column Names, even what not using 'When'?? Hi Mark, You can use JDBC driver provided by Amazon Elastic MapReduce service. When you use that driver with SQL Squirrel it returns column names. Here are the docs on how to get that driver: http://buyitnw.appspot.com/docs.amazonwebservices.com/ElasticMapReduce/latest/DeveloperGuide/index.html?UsingEMR_Hive.html Regards, Peter Sirota From: Sunderlin, Mark [mailto:mark.sunder...@teamaol.com] Sent: Thursday, February 17, 2011 1:00 PM To: user@hive.apache.org Subject: Hive Not Returning Column Names, even what not using 'When'?? When using either Hue or using Squirrel and jdbc, I get "_col0, _col1, _col2 ..." as my columns names when querying my hive tables. I see in https://issues.apache.org/jira/browse/HIVE-1346 that this is a known issue when using the where clause, but I get in circumstances other than using a where clause. This query, to return counts of rows of a log file that are of a certain log record type value, also returns generic column names: select sum(case cast(raw.log_type_id as int) when 1 then 1 else 0 end) type_1, sum(case cast(raw.log_type_id as int) when 2 then 1 else 0 end) type_2, sum(case cast(raw.log_type_id as int) when 6 then 1 else 0 end) type_6, from raw_log raw Is this a variation on the same issue, or a new issue, or it is something I am doing wrong? --- Mark E. Sunderlin Solutions Architect |AOL Data Warehouse P: 703-256-6935 | C: 540-327-6222 AIM: MESunderlin 22000 AOL Way | Dulles, VA | 20166
