Hey Jeremy - Looks like this was more trouble than it should have been. Can u help us by filing a couple of Jiras on expected behavior:
1. should 'location ..' clause in create table force people to specify uri? Or should it use fs.default.name from hadoop configuration and tell user that it's doing so? 2. load data command - should it use scheme/authority of the target table instead of using the fs.default.name from hadoop config? Would fixing these issues have helped? Thanks Joydeep ________________________________ From: Jeremy Chow [mailto:coderp...@gmail.com] Sent: Tuesday, January 13, 2009 9:42 PM To: hive-user@hadoop.apache.org Subject: Re: Can hive load a table from a SequenceFile? Hi all, It seems like a bug of hive. The URI of table is valued by this code in Hive.java, table.setDataLocation(new URI(tTable.getSd().getLocation())); and the tTable.getSd().getLocation() is a string without prefix like "file://" and "hdfs://" , it will causes that the scheme of URI object be null. Jeremy -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. http://coderplay.javaeye.com