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
can you check dfs health?
I think few of your nodes are down
On Thu, Jul 5, 2012 at 12:17 PM, shaik ahamed shaik5...@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 *
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 shaik5...@gmail.com wrote:
Hi All,
Im not
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
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 nitinpawar...@gmail.comwrote:
can you check dfs health?
I think few of your nodes are down
On Thu, Jul 5, 2012 at 12:17 PM, shaik ahamed shaik5...@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 shaik5...@gmail.com wrote:
read for hadoop dfs fsck command
On Thu, Jul 5, 2012 at 12:29 PM, shaik ahamed shaik5...@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 nitinpawar...@gmail.comwrote:
can you check dfs health?
Thanks for ur reply nitin ..
On Thu, Jul 5, 2012 at 12:30 PM, Nitin Pawar nitinpawar...@gmail.comwrote:
read for hadoop dfs fsck command
On Thu, Jul 5, 2012 at 12:29 PM, shaik ahamed shaik5...@gmail.com wrote:
Hi Nitin,
How can i check the dfs health? could u plz guide me the
Hi Yogesh
No issues seen on the first look. Can you run the sqoop import with --verbose
option and post in the console dump?
Are you having multiple hive installation? If so please verify whether you are
using the same hive for both SQOOP import and then for verifying data using
hive cli.
Hi Bejoy
I have confirmed hive installation its same for both
I used command echo $HIVE_HOME on both sqoop terminal and hive terminal
both result the same Path
HADOOP/hive
I am new to Hive and sqoop, would you please give an example using -verbose
option with this command
sqoop import
Hi Yogesh
Please try out this command
sqoop import --connect
jdbc:mysql://localhost:3306/Demo --username sqoop1 --password SQOOP1
-table Dummy --hive-table dummyhive --create-hive-table --hive-import
--hive-home HADOOP/hive --verbose
Regards
Bejoy KS
Hi Yogesh
Verbose option won't create any difference in operation, but gives more logging
information on console which could be helpful to search for any hints.
So please post in your console dump/log along with the sqoop import command
with verbose enabled.
Regards
Bejoy KS
Hi Yogesh
The verbose option didn't work there as there is no DEBUG logging, can you
please add the verbose to the beginning of your sqoop command?
Lemme frame a small sqoop import sample or you, Please run this command and
post in the console log
sqoop import --verbose --connect
How can I list all the views in hive? I can't seem to figure out how to
do it with HQL.
Hi Stephen
You can see the views as well along with tables using the
Show tables;
command.
--Original Message--
From: Stephen R. Scaffidi
To: user@hive.apache.org
ReplyTo: user@hive.apache.org
ReplyTo: sscaff...@tripadvisor.com
Subject: How to list all views
Sent: Jul 5, 2012 20:38
How
Thank you, but what I need is to list only the views, or conversely,
only the actual tables.
On 07/05/2012 11:14 AM, Bejoy KS wrote:
Hi Stephen
You can see the views as well along with tables using the
Show tables;
command.
--Original Message--
From: Stephen R. Scaffidi
To:
There may be a way to select table_name's from the metastore...if so name
your views like *_view and select for those table names.
Of course if you can query the metastore there's probably an even better
way where you don't have to name you view's anything special, and just
search for a table
I've modified hive to notify jobId for monitoring purpose. Check the issue
and vote for acceptance ^^
https://issues.apache.org/jira/browse/HIVE-3235
2012/7/6 VanHuy Pham huy.pham...@gmail.com
Hi all,
I have been interested in getting the debug information and display it
to clients.
Mark,
JDBC does not talk to hive via thrift server. I shut down the thrift
server, JDBC still works. However, you might be right in the case of
non-local connection, or as they call standalone mode.
Van
On Thu, Jul 5, 2012 at 8:47 PM, Mark Grover mgro...@oanda.com wrote:
Hi Ransom,
JDBC
19 matches
Mail list logo