Hi David,
Thanks for you suggestion. I still cannot figure out the error from the log.
1. execute:
hcat -e "import from 'hdfs://127.0.0.1:54310/usr/hduser/simple/tab1
I got:
Hive history file=/tmp/hduser/hive_job_log_hduser_201203141333_129545723.txt
FAILED: Error in semantic analysis: Exception while processing
2. In /tmp/hive.log, the latest entry is:
2012-03-14 13:33:27,094 ERROR ql.Driver
(SessionState.java:printError(374)) - FAILED: Error in semantic
analysis: Exception while processing
org.apache.hadoop.hive.ql.parse.SemanticException: Exception while
processing
at
org.apache.hadoop.hive.ql.parse.ImportSemanticAnalyzer.analyzeInternal(ImportSemanticAnalyzer.java:269)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:238)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:377)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:844)
at org.apache.hcatalog.cli.HCatDriver.run(HCatDriver.java:42)
at org.apache.hcatalog.cli.HCatCli.processCmd(HCatCli.java:225)
at org.apache.hcatalog.cli.HCatCli.processLine(HCatCli.java:181)
at org.apache.hcatalog.cli.HCatCli.main(HCatCli.java:145)
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:156)
Caused by: java.lang.IllegalArgumentException: Wrong FS:
hdfs://127.0.0.1:54310/usr/ hduser/simple/tab1/_metadata, expected:
hdfs://localhost:54310
at org.apache.hadoop.fs.FileSystem.checkPath(FileSystem.java:310)
at
org.apache.hadoop.hdfs.DistributedFileSystem.checkPath(DistributedFileSystem.java:99)
at
org.apache.hadoop.hdfs.DistributedFileSystem.getPathName(DistributedFileSystem.java:155)
at
org.apache.hadoop.hdfs.DistributedFileSystem.open(DistributedFileSystem.java:178)
at org.apache.hadoop.fs.FileSystem.open(FileSystem.java:356)
at
org.apache.hadoop.hive.ql.parse.EximUtil.readMetaData(EximUtil.java:207)
at
org.apache.hadoop.hive.ql.parse.ImportSemanticAnalyzer.analyzeInternal(ImportSemanticAnalyzer.java:93)
... 13 more
3. In /tmp/hduser/hive_job_log_hduser_201203141333_129545723.txt:
SessionStart SESSION_ID="hduser_201203141333" TIME="1331746404483"
Do I need to install the latest version from svn/git repository? Right
now, I am using release 0.2.0.
Regards,
-Monnand
David Capwell wrote, On 03/14/2012 09:31 AM:
Looks like the real error didn't propagate up. Check the server logs.
Also there should be a Clint log under /tmp/yourusrtnsme. Three should
have more details
On Mar 14, 2012 3:53 AM, "[email protected] <mailto:[email protected]>"
<[email protected] <mailto:[email protected]>> wrote:
Dear all,
I have just setup HCatalog on my machine and trying to import some
simple dataset to it. Here is how I import the data:
The data on HDFS:
$ hadoop dfs -cat /usr/hduser/simple/tab1
1 1
2 3
NOTE: They are tab separated.
import the data (and got an error):
$ hcat -e "import from 'hdfs://127.0.0.1:54310/usr/
hduser/simple/tab1 <http://127.0.0.1:54310/usr/hduser/simple/tab1>'"
Hive history file=/tmp/hduser/hive_job_log_
hduser_201203140648_814739413. txt
FAILED: Error in semantic analysis: Exception while processing
>From the error, it seems that there is something wrong with my
import statement. I also tried other possible solutions (create a
table and then import, etc.). But none of them works. So what is the
exact meaning of this error and how can I (correctly) import the
data? (I did read the documents on line. But it doesn't help.)
Regards,
-Monnand
