very quick if i query hdfs data ,but very slow when i query hbase data ,why?

2013-09-10 Thread ch huang
hi,all: i have a question ,when my table data is on hdfs,it's very quick,but when table data on hbase ,it's very slow when i query use hive,why?

RE: error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely

2013-09-10 Thread shouvanik.haldar
Hi Nitin, Latest update. Am able to start metastore and table getting created. But when I execute the command “hive> select * from table_name”, hive compaints Failed with exception java.io.IOException:java.lang.IllegalArgumentException: AWS Access Key ID and Secret Access Key must be specified a

RE: error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely

2013-09-10 Thread shouvanik.haldar
Sorry again. File system will be hadoop Sent from my Windows Phone From: Haldar, Shouvanik Sent: ‎10-‎09-‎2013 16:59 To: user@hive.apache.org Subject: RE: error executing the tutorial -> https://c

Re: error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely

2013-09-10 Thread Nitin Pawar
Ok, so back to basics. correct me If I am wrong You are trying to setup YARN using s3 as file system? Then you want to use hive on top of it. On Tue, Sep 10, 2013 at 4:48 PM, wrote: > The issue is if I paste it in core-site.xml of Hadoop on the node in > question, then will starting datanod

RE: error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely

2013-09-10 Thread shouvanik.haldar
The issue is if I paste it in core-site.xml of Hadoop on the node in question, then will starting datanode would do only? Actually,. I am a bit confused what all daemons to start. I have a YARN architecture running 1 separate - Resource Manager, 1 NameNode & 4 datanodes. From: Nitin Pawar [ma

Re: error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely

2013-09-10 Thread Nitin Pawar
There is not more to start. If hive is not starting properly, it will not start at all so you are doing ok. Problem is when you create table, hive tries to create a directory with that name if its not existing. Just try to put those two settings inside core-site.xml and see if the hdfs can use it

RE: error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely

2013-09-10 Thread shouvanik.haldar
The values are showing when I run "hive> set;" command. But it's not getting identified. I guess I am not starting HIVE properly. Do you know what are the steps? From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Tuesday, September 10, 2013 4:04 PM To: user@hive.apache.org Subject: Re: err

Re: error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely

2013-09-10 Thread Nitin Pawar
>From the config file it looks ok. Not really sure why it is not picking up when you run it via hive cli. Can you try putting these in core-site.xml of hdfs. fs.s3n.awsAccessKeyId ID fs.s3n.awsSecretAccessKey SECRET On Tue, Sep 10, 2013 at 3:11 PM, wrote: > Hi Nitin,

RE: error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely

2013-09-10 Thread shouvanik.haldar
Hi Nitin, PFA hive-site.xml. I wanted to start Hortonworks HIVE. Can you please help. Thanks, Shouvanik From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Tuesday, September 10, 2013 11:15 AM To: user@hive.apache.org Subject: Re: error executing the tutorial -> https://cwiki.apache.org/co