Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Configure Hive in Cluster


Copy link to this message
-
Re: Configure Hive in Cluster
Below details are the cluster configuration

Configured Capacity         : 82.8 GB
DFS Used                          : 1.16 GB
Non DFS Used                  : 31.95 GB
DFS Remaining                : 49.69 GB
DFS Used%                      : 1.4 %
DFS Remaining%              : 60.01 %
Live Nodes <http://localhost:50070/dfsnodelist.jsp?whatNodes=LIVE>      
: 2
Dead Nodes <http://localhost:50070/dfsnodelist.jsp?whatNodes=DEAD>     : 0
Decommissioning Nodes
<http://localhost:50070/dfsnodelist.jsp?whatNodes=DECOMMISSIONING> : 0
Number of Under-Replicated Blocks : 0

My Select Query is:

"select * from tweet where Id = 810;"

This query takes 15 min to complete
On Thursday 17 January 2013 12:29 PM, Nitin Pawar wrote:
> how many number of nodes you have for select query?
> whats your select query?
>
> if its just a select * from table then it does not run any mapreduce job
> so its just taking time to show data on your screen if you are using
> that query
>
>
> On Thu, Jan 17, 2013 at 12:24 PM, venkatramanan
> <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
> wrote:
>
>     I didnt set any hive parameters and my total table size is 610 MB
>     only
>
>
>
>     On Thursday 17 January 2013 12:11 PM, Nitin Pawar wrote:
>>     a bit more details on size of table and select query will help
>>     also did you set any hive parameters ?
>>
>>
>>     On Thu, Jan 17, 2013 at 12:12 PM, venkatramanan
>>     <[EMAIL PROTECTED]
>>     <mailto:[EMAIL PROTECTED]>> wrote:
>>
>>         Hi All,
>>
>>         Am Newbie in apache hive. I have create a table and thats
>>         points to the HDFS Folder path and its takes 15 min to
>>         execute the simple "*select*" stmt, Can anyone suggest me for
>>         a best practices and performance improvement on hive.
>>
>>         Thanks in Advance
>>
>>         Venkat
>>
>>
>>
>>
>>     --
>>     Nitin Pawar
>
>
>
>
> --
> Nitin Pawar