Hi Aniket,
I just got it and pasted below:
2011-12-02 12:10:20,379 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-12-02 12:10:20,379 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-12-02 12:10:20,395 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-12-02 12:10:20,395 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-12-02 12:10:20,395 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-12-02 12:10:20,395 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-12-02 12:10:23,339 ERROR ql.Driver
(SessionState.java:printError(343)) - FAILED: Error in semantic
analysis: Line 1:23 Cannot insert into target table because column
number/types are different pokes: Table insclause-0 has 3 columns, but
query has 1 columns.
org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:23 Cannot
insert into target table because column number/types are different
pokes: Table insclause-0 has 3 columns, but query has 1 columns.
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genConversionSelectOperator(SemanticAnalyzer.java:3859)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFileSinkPlan(SemanticAnalyzer.java:3763)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:5480)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:6016)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:6601)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:238)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:340)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:425)
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)
2011-12-02 12:10:45,159 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-12-02 12:10:45,159 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-12-02 12:10:45,159 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-12-02 12:10:45,159 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-12-02 12:10:45,159 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-12-02 12:10:45,159 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-12-02 12:10:48,820 WARN mapred.JobClient
(JobClient.java:configureCommandLineOptions(539)) - Use
GenericOptionsParser for parsing the arguments. Applications should
implement Tool for the same.
2011-12-02 12:11:23,287 ERROR exec.MapRedTask
(SessionState.java:printError(343)) - Ended Job =
job_201112011620_0005 with errors
2011-12-02 12:11:23,739 ERROR ql.Driver
(SessionState.java:printError(343)) - FAILED: Execution Error, return
code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
On Fri, Dec 2, 2011 at 11:54 AM, Aniket Mokashi <aniket...@gmail.com> wrote:
> I guess this is not the right file. You should look into hive app logs..
> You can paste the full exception stack.
>
> Thanks,
> Aniket
>
> On Thu, Dec 1, 2011 at 10:22 PM, Bhavesh Shah <bhavesh25s...@gmail.com>wrote:
>
>> Hi,
>> Tthe content of file is too large, that's why I am attaching file.
>> Pls check it out.
>> Thanks.
>>
>> -----Original Message-----
>> From: Aniket Mokashi [mailto:aniket...@gmail.com]
>> Sent: Friday, December 02, 2011 11:46 AM
>> To: dev@hive.apache.org
>> Subject: Re: Problem in running Hive Queries
>>
>> you should open
>> /tmp/Bhavesh.Shah/hive_job_log_Bhavesh.Shah_201112021007_2120318983.txt.
>> That will give you more hints. Paste some lines from there on this thread.
>>
>> Thanks,
>> Aniket
>>
>> On Thu, Dec 1, 2011 at 10:11 PM, Bhavesh Shah
>> <bhavesh25s...@gmail.com>wrote:
>>
>> > Hi,
>> >
>> > I am new to Hive. I have configured Hadoop and Hive on Windows 7
>> > through Cygwin.
>> >
>> > Currently I am running hive queries on Hive CLI.
>> >
>> > I want to ask question that:
>> >
>> > When I enter the hive queries I get the following errors as:
>> >
>> > Query:
>> >
>> > bin/hive -e "insert overwrite table pokes select a.* from invites a
>> > where a.ds='2008-08-15';"
>> >
>> >
>> >
>> > Errors:
>> >
>> > bin/hive -e "insert overwrite table pokes select a.* from invites a
>> > where a.ds='2008-08-15';"
>> >
>> > Hive history
>> >
>> > file=/tmp/Bhavesh.Shah/hive_job_log_Bhavesh.Shah_201112021007_21203189
>> > 83.txt
>> >
>> > Total MapReduce jobs = 2
>> >
>> > Launching Job 1 out of 2
>> >
>> > Number of reduce tasks is set to 0 since there's no reduce operator
>> >
>> > Starting Job = job_201112011620_0004, Tracking URL =
>> > http://localhost:50030/jobdetails.jsp?jobid=job_201112011620_0004
>> >
>> > Kill Command = C:\cygwin\home\Bhavesh.Shah\hadoop-0.20.2\/bin/hadoop
>> > job
>> > -Dmapred.job.tracker=localhost:9101 -kill job_201112011620_0004
>> >
>> > 2011-12-02 10:07:30,777 Stage-1 map = 0%, reduce = 0%
>> >
>> > 2011-12-02 10:07:57,796 Stage-1 map = 100%, reduce = 100%
>> >
>> > Ended Job = job_201112011620_0004 with errors
>> >
>> > FAILED: Execution Error, return code 2 from
>> > org.apache.hadoop.hive.ql.exec.MapRedTask
>> >
>> >
>> >
>> >
>> >
>> > So what could be the solution? Pls suggest me.
>> >
>> >
>> >
>> >
>> >
>> > Thanks and Regards,
>> >
>> > Bhavesh Shah.
>> >
>> >
>>
>>
>> --
>> "...:::Aniket:::... Quetzalco@tl"
>>
>
>
>
> --
> "...:::Aniket:::... Quetzalco@tl"
--
Regards,
Bhavesh Shah
