Search Discussions
-
Good Friday! I was trying to apply certain level of security in our hive data warehouse, by modifying access mode of directories and files on hdfs to 755 I think it's good enough for a new user to ...
Echo Li
Nov 22, 2013 at 7:36 pm
Dec 1, 2013 at 6:42 am -
The Apache Hive PMC has voted to make Jitendra Nath Pandey and Eric Hanson committers on the Apache Hive project. Please join me in congratulating Jitendra and Eric! Thanks. Carl
Carl Steinbach
Nov 21, 2013 at 11:29 pm
Nov 23, 2013 at 4:48 am -
The Apache Hive PMC has voted to make Xuefu Zhang a committer on the Apache Hive project. Please join me in congratulating Xuefu! Thanks. Carl
Carl Steinbach
Nov 4, 2013 at 4:06 am
Nov 7, 2013 at 12:14 am -
I am pleased to announce that Harish Butani has been elected to the Hive Project Management Committee. Please join me in congratulating Harish! Thanks. Carl
Carl Steinbach
Nov 15, 2013 at 1:18 am
Nov 16, 2013 at 12:50 am -
Hi, I have setup WebHCat that is bundled with Hive 0.11.0. I am able to kick of map reduce jobs with the REST API successfully. However I am having some issues with Hive commands over REST. The ...
Jonathan Hodges
Nov 29, 2013 at 3:29 pm
Dec 30, 2013 at 6:11 pm -
The Apache Hive PMC has voted to make Prasad Mujumdar a committer on the Apache Hive Project. Please join me in congratulating Prasad! Thanks. Carl
Carl Steinbach
Nov 11, 2013 at 2:43 am
Nov 12, 2013 at 1:10 am -
Hi, Does Hive 0.12 run on Hadoop 2.2? if it does, anything special about installing it or running hive? Will hive start a M/R ApplicationMaster by itself or should I start one for it? Many thanks ...
Bill Q
Nov 14, 2013 at 7:36 am
Nov 18, 2013 at 12:33 pm -
A word of warning for users of HiveServer2 - version 0.11 at least. This puppy has the ability crash and/or hang your server with a memory leak. Apparently its not new since googling shows this ...
Stephen Sprague
Nov 18, 2013 at 9:00 pm
Nov 20, 2013 at 1:26 am -
Hi, All When I try to compile the latest code of hive using "mvn install" I got these messages. How to pass these unit tests? Did I miss something? I was compiling the code on ubuntu 13.04 And my ...
金杰
Nov 5, 2013 at 1:32 pm
Nov 7, 2013 at 10:58 pm -
Hi, I have a messy log file which I want to use to create a table, I am only interested to retrieve 3 columns (time,ADD,files),which are in bold. Sample entry from log file *: 13-11-23 06:23:45 [ADD] ...
Baahu
Nov 23, 2013 at 1:37 pm
Nov 25, 2013 at 5:37 am -
The Apache Hive PMC has voted to make Lefty Leverenz a committer and PMC member on the Apache Hive Project. Please join me in congratulating Lefty! Thanks. Carl
Carl Steinbach
Nov 17, 2013 at 5:20 am
Nov 17, 2013 at 3:55 pm -
Hello, I am using sqoop to import data from oracle into hive. Below is my SQL: nohup sqoop import --connect "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxx)(PORT = xxxx)) ...
Sunita Arvind
Nov 11, 2013 at 9:49 pm
Nov 12, 2013 at 2:54 pm -
Hi, all, I am trying to build hive from source and start CLI. What I did is (1) git clone the source (2) mvn clean install -DskipTests (3) cp */target/*.jar lib/ ---- this step basically copy all jar ...
Zhang Xiaoyu
Nov 6, 2013 at 2:14 am
Nov 7, 2013 at 1:53 am -
Hi, I would like update/fix some contents on the performance test part. My user name is xiaom. Thanks, Xiao
Xiao Meng
Nov 29, 2013 at 11:00 pm
Dec 12, 2013 at 1:49 am -
Hello, I am getting this error (appearing after sending *SHOW TABLES;*query). $ hive --service hiveserver2 Starting HiveServer2 Exception in thread "pool-4-thread-1" java.lang.OutOfMemoryError: Java ...
Rok Kralj
Nov 20, 2013 at 10:24 pm
Nov 25, 2013 at 12:22 pm -
Hi All, I have the following skewed table "addresses_1" select id, count(*) c from addresses_1 group by id order by c desc limit 10; 142624653 1554806 198477395 958492 102641838 220181 138947865 ...
Rajesh Balamohan
Nov 14, 2013 at 1:06 am
Nov 14, 2013 at 11:29 am -
I am looking for guidance (read examples) on tuning ORC settings for my data. I see the documentation that shows the defaults, as well as a brief description of what it is. What I am looking for is ...
John Omernik
Nov 12, 2013 at 11:16 pm
Nov 14, 2013 at 4:30 am -
All, I want to create partitions like the below and create a hive external table. How can i do that ? /data1/customer/id<1000 /data1/customer/id 1000 and id < 2000 /data1/customer/id 2000 Is this ...
Raj Hadoop
Nov 3, 2013 at 10:51 pm
Nov 4, 2013 at 10:43 pm -
hi all, We are using hive for Ad-hoc querying and have a hive table which is partitioned on two fields (date,id).Now for each date there are around 1400 ids so on a single day around that many ...
Sreenath
Nov 25, 2013 at 10:50 am
Nov 26, 2013 at 10:54 am -
Hi, I have a table which has 3 columns combined together to form a primary key. If I do Select count(distinct col1,col2,col3) from table_name; And Select count(a.*) from (select ...
Mayank Bansal
Nov 21, 2013 at 3:14 pm
Nov 25, 2013 at 1:46 pm -
Hi, We often have map-only queries that result in a large number of small output files (in the thousands). Although this doesn't affect CLI, when users try to view/download the query result in Hue, ...
Eric Chu
Nov 21, 2013 at 5:28 pm
Nov 21, 2013 at 10:19 pm -
Hi, we are using gradle as our build tool. I need hive-exec to use class OrcFile. As soon as I pull in hive-exec 0.12.0 as a dependency my build starts to fail with java.lang.NoClassDefFoundError ...
Kristof Vanbecelaere
Nov 21, 2013 at 12:55 pm
Nov 21, 2013 at 6:25 pm -
In vertica, if I have a column sorted, and the same value repeat 1M times, it only used very small storage as it only stores (value, 1M). But in ORC, looks like the max length is less than 200 ( not ...
Qihua wu
Nov 11, 2013 at 2:22 pm
Nov 11, 2013 at 6:00 pm -
Hello, I am getting the following exception when I try to run a query. Can any body help me what the problem might be in this scenario. Thanks for you time. 2013-11-07 09:23:38,498 FATAL ExecMapper ...
Narla,Venkatesh
Nov 7, 2013 at 3:49 pm
Nov 11, 2013 at 7:19 am -
Hi, I am sending this to the three dist-lists of Hadoop, Hive and Sqoop as this question is closely related to all the three areas. I have this requirement. I have a big table in Oracle (about 60 ...
Raj Hadoop
Nov 3, 2013 at 3:40 pm
Nov 4, 2013 at 4:14 am -
Hi, I am using Hive 0.12 with Hadoop 2.2 and trying to insert data in a new ORC table with an INSERT SELECT statement from a TEXT file based table and I am running into the following error (I have ...
Juan Martin Pampliega
Nov 27, 2013 at 1:03 pm
Dec 10, 2013 at 12:10 am -
Hive is configured with remote metastore and kerberos ,and it works fine . But now ,I want to config hive authorization ,and I modify hive-site.xml like this: <property <name ...
David1990111
Nov 14, 2013 at 5:54 am
Nov 14, 2013 at 6:23 am -
Hello, I'm writing a generic UDAF function that closely resembles SUM() with the main difference being that it accepts an array datatype parameter and returns an array datatype. I've already done ...
Ross Levin
Nov 11, 2013 at 7:32 pm
Nov 12, 2013 at 3:51 am -
Hi, All I found a line in pom.xml <test.warehouse.scheme pfile://</test.warehouse.scheme You can check it on https://github.com/apache/hive/blob/trunk/pom.xml#L61 What is pfile? Is pfile a file ...
金杰
Nov 10, 2013 at 11:09 am
Nov 11, 2013 at 10:53 pm -
Is there any way to stop hive metastore without killing PID. Thanks & Regards, Rinku Garg The information contained in this message is proprietary and/or confidential. If you are not the intended ...
Garg, Rinku
Nov 6, 2013 at 11:43 am
Nov 6, 2013 at 7:22 pm -
Hi, I ran "mvn clean install -DskipTests; cd itests; mvn clean install -DskipTests" and got the following error. Error ======= [ERROR] Failed to execute goal ...
Mohammad Islam
Nov 3, 2013 at 3:49 am
Nov 4, 2013 at 7:08 am -
hi, We are building ms sql cube by linkedserver connecting to hiveserver with Cloudera's ODBC driver. There are two test results: 1. hiveserver1 running on 2CPUs, 8G mem, took about 8 hours 2 ...
B C
Nov 6, 2013 at 2:17 am
Jan 19, 2014 at 6:44 am -
Hello everyone, I have two questions on join optimizations in Hive, one of which I believe is a bug in the 0.11.0 release. 1. From Hive online documentation I see that multiple map joins can be ...
Adrian Popescu
Nov 15, 2013 at 9:21 pm
Dec 13, 2013 at 7:17 pm -
Hi all, We've been running into this problem a lot recently on a particular reduce task. I'm aware that I can work around it by uping the "mapred.task.timeout". However, I would like to know what the ...
Krishna Rao
Nov 29, 2013 at 12:12 pm
Nov 29, 2013 at 8:55 pm -
hi,maillist: i add some new columns to hive table ,but find when i use beeline, or write my own java code,i can not get these new columns value,but when i use hive shell,it's ok 0 ...
Ch huang
Nov 28, 2013 at 2:09 am
Nov 28, 2013 at 2:34 am -
Hello, I'd like to run a few TPC-H queries on Hive 0.12. I've found the TPC-H scripts here: https://issues.apache.org/jira/browse/HIVE-600. but noticed that these scripts were generated a long time ...
Avrilia Floratou
Nov 22, 2013 at 6:31 pm
Nov 22, 2013 at 7:44 pm -
what is the error ? -- Nitin Pawar
Nitin Pawar
Nov 15, 2013 at 11:00 am
Nov 15, 2013 at 11:30 am -
When trying to create table in Hive I am always getting the following error always. Not able to do any hive DDL operations, FAILED: Error in metadata ...
Valluri, Sathish
Nov 15, 2013 at 9:42 am
Nov 15, 2013 at 10:47 am -
Hi, I have a web log files (text format). I want to load these files to a Hive table in compressed format. How do I do it ? Should I compress the text file (using any Linux utilities) and then create ...
Raj Hadoop
Nov 12, 2013 at 1:10 am
Nov 12, 2013 at 4:26 am -
Hi all, I am using Hadoop cdh3u6 and apache hive 0.10. I run the summary sql as follow : SELECT pt, count(1), sum(flow_byte), count(distinct t.user_id), count(distinct t.phone_no), max(t.user_ip), ...
Asword
Nov 6, 2013 at 9:44 am
Nov 12, 2013 at 3:31 am -
Hello, Quick question about Hive and Avro. Can I create an Avro scheme that uses aliases? I have tried a couple different ways, but so far I have not been able to get a hive query to return data for ...
Matthew Langton
Nov 8, 2013 at 7:51 am
Nov 8, 2013 at 9:09 pm -
Hi all, I'm using hive-12. I have a file that contains 10 integer columns stored in ORC format. The ORC file is zlib compressed and indexing is enabled. I'm running a simple select count(*) with a ...
Avrilia Floratou
Nov 8, 2013 at 12:05 am
Nov 8, 2013 at 2:00 am -
Hello. I have a set of complex structured objects that I would like to put into hive and use it's sql to query data from those objects. Now, since they are complex structures, defining a schema for ...
Miljan Markovic
Nov 7, 2013 at 11:42 am
Nov 7, 2013 at 1:00 pm -
Time taken: 0.272 seconds hive (default) drop table demo3; OK Time taken: 60.524 seconds hive (default) create table demo3 like demo; OK Time taken: 0.273 seconds
Ch huang
Nov 28, 2013 at 2:06 am
Nov 28, 2013 at 2:06 am -
Hi, I have development cluster installed with Hive 0.12 running on top of Hadoop 2.2.0. I have set the following properties values in the .hiverc file and when running queries in the hive command ...
Juan Martin Pampliega
Nov 26, 2013 at 6:58 pm
Nov 26, 2013 at 6:58 pm -
Hi, I want to customize the hive-site.xml to add some extra properties to be used for a UDF. The UDF is a part of the view to be created. So , i tried setting the path through hivecli as below: set ...
Swagatika Tripathy
Nov 24, 2013 at 6:22 am
Nov 24, 2013 at 6:22 am -
Hi, all, I'm running Hive-0.9.0-cdh4.1.2 on a cluster consisting of 3 nodes, I was wondering if I would like to run multiple queries simultaneously? BTW, I have set "hive.exec.parallel" to true in ...
Lin Yang
Nov 20, 2013 at 11:34 am
Nov 20, 2013 at 11:34 am -
Hi, I am writing a MR job to generate data for Hive. the code generates output with Text format pretty OK job.setOutputKeyClass(NullWritable.class); job.setOutputValueClass(Text.class); But when I ...
Zhang Xiaoyu
Nov 20, 2013 at 2:12 am
Nov 20, 2013 at 2:12 am -
There are some discussions on this https://issues.apache.org/jira/browse/HIVE-3822 However, one person is stating there is not an issue with timestamp, thus I am asking this question: is this a bug ...
John Omernik
Nov 19, 2013 at 6:15 pm
Nov 19, 2013 at 6:15 pm -
It imports the classes under package of org.apache.hadoop.mapred instead of org.apache.hadoop.mapreduce, which means it used old API. How can I run it using new mapreduce API?
Qihua wu
Nov 18, 2013 at 6:01 am
Nov 18, 2013 at 6:01 am
Group Overview
group | user |
categories | hive, hadoop |
discussions | 66 |
posts | 222 |
users | 89 |
website | hive.apache.org |
89 users for November 2013
Archives
- June 2016 (177)
- May 2016 (265)
- April 2016 (244)
- March 2016 (368)
- February 2016 (323)
- January 2016 (323)
- December 2015 (347)
- November 2015 (305)
- October 2015 (279)
- September 2015 (386)
- August 2015 (291)
- July 2015 (176)
- June 2015 (305)
- May 2015 (227)
- April 2015 (345)
- March 2015 (332)
- February 2015 (230)
- January 2015 (129)
- December 2014 (252)
- November 2014 (196)
- October 2014 (252)
- September 2014 (288)
- August 2014 (265)
- July 2014 (389)
- June 2014 (274)
- May 2014 (203)
- April 2014 (296)
- March 2014 (270)
- February 2014 (301)
- January 2014 (252)
- December 2013 (230)
- November 2013 (222)
- October 2013 (275)
- September 2013 (315)
- August 2013 (364)
- July 2013 (419)
- June 2013 (407)
- May 2013 (319)
- April 2013 (206)
- March 2013 (344)
- February 2013 (268)
- January 2013 (318)
- December 2012 (313)
- November 2012 (244)
- October 2012 (318)
- September 2012 (373)
- August 2012 (380)
- July 2012 (487)
- June 2012 (454)
- May 2012 (458)
- April 2012 (343)
- March 2012 (337)
- February 2012 (207)
- January 2012 (265)
- December 2011 (235)
- November 2011 (182)
- October 2011 (199)
- September 2011 (211)
- August 2011 (277)
- July 2011 (152)
- June 2011 (149)
- May 2011 (244)
- April 2011 (127)
- March 2011 (265)
- February 2011 (284)
- January 2011 (235)
- December 2010 (143)
- November 2010 (137)
- October 2010 (231)
- September 2010 (254)
- August 2010 (278)
- July 2010 (161)
- June 2010 (262)
- May 2010 (132)
- April 2010 (126)
- March 2010 (178)
- February 2010 (366)
- January 2010 (156)
- December 2009 (110)
- November 2009 (146)
- October 2009 (252)
- September 2009 (215)
- August 2009 (187)
- July 2009 (322)
- June 2009 (106)
- May 2009 (97)
- April 2009 (160)
- March 2009 (173)
- February 2009 (139)
- January 2009 (152)
- December 2008 (105)
- November 2008 (33)