incubator-hcatalog-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "monnand@gmail.com" <monn...@gmail.com>
Subject Re: How to import data
Date Wed, 14 Mar 2012 17:42:17 GMT
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, "monnand@gmail.com <mailto:monnand@gmail.com>"
> <monnand@gmail.com <mailto:monnand@gmail.com>> 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
>


Mime
View raw message