Hey zheng, I know that command you refered. My meaning is that an interface which our programs can invoke it , not just a command. BTW, another questions about this command, I want to create a table for loading data from a plain file in the next step, following the tutorial on http://wiki.apache.org/hadoop/Hive/UserGuide. But it failed, throwing a exception liked below, hive> CREATE TABLE u_data (userid INT, movieid INT, rating INT, unixtime TIMESTAMP) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE; ERROR: DDL specifying type timestamp which has not been defined java.lang.RuntimeException: specifying type timestamp which has not been defined at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.FieldType(thrift_grammar.java:1879) at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Field(thrift_grammar.java:1545) at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.FieldList(thrift_grammar.java:1501) at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Struct(thrift_grammar.java:1171) at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.TypeDefinition(thrift_grammar.java:497) at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Definition(thrift_grammar.java:439) at org.apache.hadoop.hive.serde2.dynamic_type.thrift_grammar.Start(thrift_grammar.java:101) at org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe.initialize(DynamicSerDe.java:97) at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:180) at org.apache.hadoop.hive.ql.metadata.Table.initSerDe(Table.java:141) at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:199) at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:598) at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:93) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:212) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:174) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:207) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:305) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:165) at org.apache.hadoop.mapred.JobShell.run(JobShell.java:54) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79) at org.apache.hadoop.mapred.JobShell.main(JobShell.java:68)
FAILED: Error in metadata: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException java.lang.RuntimeException: specifying type timestamp which has not been defined) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Time taken: 2.462 seconds How can I fix it? On Mon, Jan 12, 2009 at 11:52 AM, Zheng Shao <zsh...@gmail.com> wrote: > Hi Jeremy, > > Yes! There is a command called "LOAD DATA INPATH" which loads (actually > moves) files from HDFS, and "LOAD DATA LOCAL INPATH" which loads files from > local file system. > Please take a look at the README file in hive code for the full examples. > > > Zheng > > > On Sun, Jan 11, 2009 at 7:43 PM, Jeremy Chow <coderp...@gmail.com> wrote: > >> Hi list, >> Is there any interface in hive to let us load a table from a flat text >> file? and Is it a parallel process? >> Can anyone give me some explanation about above? >> >> >> Thanks, >> Jeremy >> -- >> My research interests are distributed systems, parallel computing and >> bytecode based virtual machine. >> >> http://coderplay.javaeye.com >> > > > > -- > Yours, > Zheng > -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. http://coderplay.javaeye.com
