You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by shaik ahamed <sh...@gmail.com> on 2012/07/05 08:47:53 UTC
hi users
Hi All,
Im not able to fetch the data from the hive table ,getting
the below error
FAILED: Error in semantic analysis:
hive> select * from vender;
OK
Failed with exception java.io.IOException:java.io.IOException: Could not
obtain block: blk_-3328791500929854839_1178
file=/user/hive/warehouse/vender/bigtest.txt
Time taken: 9.129 seconds
Please help me in this
Regards
shaik.
Re: hi users
Posted by Mohammad Tariq <do...@gmail.com>.
Hello shaik,
Were you able to fetch the data earlier. I mean is it
happening for the first time or you were not able to fetch the data
even once??
Regards,
Mohammad Tariq
On Thu, Jul 5, 2012 at 12:17 PM, shaik ahamed <sh...@gmail.com> wrote:
> Hi All,
>
>
> Im not able to fetch the data from the hive table ,getting
> the below error
>
> FAILED: Error in semantic analysis:
>
> hive> select * from vender;
> OK
> Failed with exception java.io.IOException:java.io.IOException: Could not
> obtain block: blk_-3328791500929854839_1178
> file=/user/hive/warehouse/vender/bigtest.txt
> Time taken: 9.129 seconds
> Please help me in this
>
> Regards
> shaik.
Re: hi users
Posted by shaik ahamed <sh...@gmail.com>.
Thanks for ur reply nitin ..
On Thu, Jul 5, 2012 at 12:30 PM, Nitin Pawar <ni...@gmail.com>wrote:
> read for hadoop dfs fsck command
>
>
> On Thu, Jul 5, 2012 at 12:29 PM, shaik ahamed <sh...@gmail.com> wrote:
>
>> Hi Nitin,
>>
>> How can i check the dfs health? could u plz guide me the steps...
>>
>> On Thu, Jul 5, 2012 at 12:23 PM, Nitin Pawar <ni...@gmail.com>wrote:
>>
>>> can you check dfs health?
>>>
>>> I think few of your nodes are down
>>>
>>>
>>> On Thu, Jul 5, 2012 at 12:17 PM, shaik ahamed <sh...@gmail.com>wrote:
>>>
>>>> Hi All,
>>>>
>>>>
>>>> Im not able to fetch the data from the hive
>>>> table ,getting the below error
>>>>
>>>> FAILED: Error in semantic analysis:
>>>>
>>>> hive> select * from vender;
>>>> OK
>>>> Failed with exception java.io.IOException:java.io.IOException: Could
>>>> not obtain block: blk_-3328791500929854839_1178
>>>> file=/user/hive/warehouse/vender/bigtest.txt
>>>> Time taken: 9.129 seconds
>>>> Please help me in this
>>>>
>>>> Regards
>>>> shaik.
>>>>
>>>
>>>
>>>
>>> --
>>> Nitin Pawar
>>>
>>>
>>
>
>
> --
> Nitin Pawar
>
>
Re: hi users
Posted by Nitin Pawar <ni...@gmail.com>.
read for hadoop dfs fsck command
On Thu, Jul 5, 2012 at 12:29 PM, shaik ahamed <sh...@gmail.com> wrote:
> Hi Nitin,
>
> How can i check the dfs health? could u plz guide me the steps...
>
> On Thu, Jul 5, 2012 at 12:23 PM, Nitin Pawar <ni...@gmail.com>wrote:
>
>> can you check dfs health?
>>
>> I think few of your nodes are down
>>
>>
>> On Thu, Jul 5, 2012 at 12:17 PM, shaik ahamed <sh...@gmail.com>wrote:
>>
>>> Hi All,
>>>
>>>
>>> Im not able to fetch the data from the hive
>>> table ,getting the below error
>>>
>>> FAILED: Error in semantic analysis:
>>>
>>> hive> select * from vender;
>>> OK
>>> Failed with exception java.io.IOException:java.io.IOException: Could not
>>> obtain block: blk_-3328791500929854839_1178
>>> file=/user/hive/warehouse/vender/bigtest.txt
>>> Time taken: 9.129 seconds
>>> Please help me in this
>>>
>>> Regards
>>> shaik.
>>>
>>
>>
>>
>> --
>> Nitin Pawar
>>
>>
>
--
Nitin Pawar
Re: hi users
Posted by shaik ahamed <sh...@gmail.com>.
Hi Nitin,
How can i check the dfs health? could u plz guide me the steps...
On Thu, Jul 5, 2012 at 12:23 PM, Nitin Pawar <ni...@gmail.com>wrote:
> can you check dfs health?
>
> I think few of your nodes are down
>
>
> On Thu, Jul 5, 2012 at 12:17 PM, shaik ahamed <sh...@gmail.com> wrote:
>
>> Hi All,
>>
>>
>> Im not able to fetch the data from the hive table ,getting
>> the below error
>>
>> FAILED: Error in semantic analysis:
>>
>> hive> select * from vender;
>> OK
>> Failed with exception java.io.IOException:java.io.IOException: Could not
>> obtain block: blk_-3328791500929854839_1178
>> file=/user/hive/warehouse/vender/bigtest.txt
>> Time taken: 9.129 seconds
>> Please help me in this
>>
>> Regards
>> shaik.
>>
>
>
>
> --
> Nitin Pawar
>
>
Re: hi users
Posted by Mohammad Tariq <do...@gmail.com>.
Increase your replication factor as suggested by Nitin. Replication
factor > 1 is a must to avoid data loss. And you can use "fsck"
command to check the HDFS. Also verify whether you are able to see all
the datanodes at the namenode WEBUI page.
Regards,
Mohammad Tariq
On Thu, Jul 5, 2012 at 12:30 PM, Nitin Pawar <ni...@gmail.com> wrote:
> if you have 2 nodes and replication factor is 1 then this is a problem,
>
> I would like to suggest minimum replication factor as 2
> this would make sure that even if 1 node is down, data is served from
> replicated blocks
>
>
> On Thu, Jul 5, 2012 at 12:27 PM, shaik ahamed <sh...@gmail.com> wrote:
>>
>> Thanks for the reply guys,
>>
>> Yesterday night im able to fecth the data .And my second node is down in
>> the sence im not able to connect to the 2 machine as i have 3 machiens 1
>> master and 2 slave .As the 2 second one im not able to connect .Is this the
>> prob for not retreiving the data, or other than this.
>>
>>
>>
>> On Thu, Jul 5, 2012 at 12:23 PM, Nitin Pawar <ni...@gmail.com>
>> wrote:
>>>
>>> can you check dfs health?
>>>
>>> I think few of your nodes are down
>>>
>>>
>>> On Thu, Jul 5, 2012 at 12:17 PM, shaik ahamed <sh...@gmail.com>
>>> wrote:
>>>>
>>>> Hi All,
>>>>
>>>>
>>>> Im not able to fetch the data from the hive table
>>>> ,getting the below error
>>>>
>>>> FAILED: Error in semantic analysis:
>>>>
>>>> hive> select * from vender;
>>>> OK
>>>> Failed with exception java.io.IOException:java.io.IOException: Could not
>>>> obtain block: blk_-3328791500929854839_1178
>>>> file=/user/hive/warehouse/vender/bigtest.txt
>>>> Time taken: 9.129 seconds
>>>> Please help me in this
>>>>
>>>> Regards
>>>> shaik.
>>>
>>>
>>>
>>>
>>> --
>>> Nitin Pawar
>>>
>>
>
>
>
> --
> Nitin Pawar
>
Re: hi users
Posted by Nitin Pawar <ni...@gmail.com>.
if you have 2 nodes and replication factor is 1 then this is a problem,
I would like to suggest minimum replication factor as 2
this would make sure that even if 1 node is down, data is served from
replicated blocks
On Thu, Jul 5, 2012 at 12:27 PM, shaik ahamed <sh...@gmail.com> wrote:
> Thanks for the reply guys,
>
> Yesterday night im able to fecth the data .And my second node is down in
> the sence im not able to connect to the 2 machine as i have 3 machiens 1
> master and 2 slave .As the 2 second one im not able to connect .Is this the
> prob for not retreiving the data, or other than this.
>
>
>
> On Thu, Jul 5, 2012 at 12:23 PM, Nitin Pawar <ni...@gmail.com>wrote:
>
>> can you check dfs health?
>>
>> I think few of your nodes are down
>>
>>
>> On Thu, Jul 5, 2012 at 12:17 PM, shaik ahamed <sh...@gmail.com>wrote:
>>
>>> Hi All,
>>>
>>>
>>> Im not able to fetch the data from the hive
>>> table ,getting the below error
>>>
>>> FAILED: Error in semantic analysis:
>>>
>>> hive> select * from vender;
>>> OK
>>> Failed with exception java.io.IOException:java.io.IOException: Could not
>>> obtain block: blk_-3328791500929854839_1178
>>> file=/user/hive/warehouse/vender/bigtest.txt
>>> Time taken: 9.129 seconds
>>> Please help me in this
>>>
>>> Regards
>>> shaik.
>>>
>>
>>
>>
>> --
>> Nitin Pawar
>>
>>
>
--
Nitin Pawar
Re: hi users
Posted by shaik ahamed <sh...@gmail.com>.
Thanks for the reply guys,
Yesterday night im able to fecth the data .And my second node is down in
the sence im not able to connect to the 2 machine as i have 3 machiens 1
master and 2 slave .As the 2 second one im not able to connect .Is this the
prob for not retreiving the data, or other than this.
On Thu, Jul 5, 2012 at 12:23 PM, Nitin Pawar <ni...@gmail.com>wrote:
> can you check dfs health?
>
> I think few of your nodes are down
>
>
> On Thu, Jul 5, 2012 at 12:17 PM, shaik ahamed <sh...@gmail.com> wrote:
>
>> Hi All,
>>
>>
>> Im not able to fetch the data from the hive table ,getting
>> the below error
>>
>> FAILED: Error in semantic analysis:
>>
>> hive> select * from vender;
>> OK
>> Failed with exception java.io.IOException:java.io.IOException: Could not
>> obtain block: blk_-3328791500929854839_1178
>> file=/user/hive/warehouse/vender/bigtest.txt
>> Time taken: 9.129 seconds
>> Please help me in this
>>
>> Regards
>> shaik.
>>
>
>
>
> --
> Nitin Pawar
>
>
Re: hi users
Posted by Nitin Pawar <ni...@gmail.com>.
can you check dfs health?
I think few of your nodes are down
On Thu, Jul 5, 2012 at 12:17 PM, shaik ahamed <sh...@gmail.com> wrote:
> Hi All,
>
>
> Im not able to fetch the data from the hive table ,getting
> the below error
>
> FAILED: Error in semantic analysis:
>
> hive> select * from vender;
> OK
> Failed with exception java.io.IOException:java.io.IOException: Could not
> obtain block: blk_-3328791500929854839_1178
> file=/user/hive/warehouse/vender/bigtest.txt
> Time taken: 9.129 seconds
> Please help me in this
>
> Regards
> shaik.
>
--
Nitin Pawar