RE: getting all null values

Check your field delimiter? -A From: Abhijit Pol [mailto:a...@rocketfuelinc.com] Sent: Friday, September 18, 2009 2:55 PM To: hive-user@hadoop.apache.org Subject: getting all null values For one of the hive table I switched from TextFile to SequenceFile format. This is how I created the new tab

getting all null values

For one of the hive table I switched from TextFile to SequenceFile format. This is how I created the new table: CREATE EXTERNAL TABLE IMPRESSIONS ( A STRING, B STRING) PARTITIONED BY(DATA_DATE STRING COMMENT 'MMdd (e.g. 20090801) on which log records are collected') ROW FORMAT DELIMITED FIELDS

Re: Strange error with hive jdbc and DBVisualizer

Vijay - I got a little bit further than that before I hit a wall. DBVisualizer isn't forgiving and requires a compliant JDBC driver. When it runs into methods that aren't implemented it throws an error and doesn't let you continue. E.g. getSchema (?) is called right after the JDBC driver connec

Strange error with hive jdbc and DBVisualizer

Hi, I'm trying to get hive jdbc work with DBVisualizer. I added a new driver using DBVisualizer driver interface and specified all the relevant jar files. DBVisualizer can register the driver fine, load it and try to use it. However, when the driver ultimately tries to initialize hive (HiveClient