Search Discussions
-
The Apache Hive PMC has voted to make Thejas Nair a committer on the Apache Hive project. Please join me in congratulating Thejas!
Carl Steinbach
Aug 20, 2013 at 10:32 am
Aug 20, 2013 at 8:54 pm -
Hello, I am started to run Hive with Lzo compression on Hortonworks 1.2 I have managed to install/configure Lzo and hive -e "set io.compression.codecs" shows me the Lzo Codecs: io.compression.codecs= ...
W00t w00t
Aug 8, 2013 at 9:03 am
Aug 19, 2013 at 8:27 am -
Hi Friends, We have configured mysql as a metastore for hive, its just throwing following error, FAILED: Error in metadata: MetaException(message:Got exception: javax.jdo.JDODataStoreException ...
Shashwat shriparv
Aug 3, 2013 at 11:59 am
Aug 8, 2013 at 4:03 am -
Hi everybody, I am coding some HiveQL script to do some calculations. I have a problem with the min() function. My hive script is below : INSERT INTO TABLE default.THM_CA_RGRP_PRODUITS_SEM SELECT ...
Jérôme Verdier
Aug 29, 2013 at 10:02 am
Aug 30, 2013 at 6:50 pm -
Hi all: I'm currently testing hive11 and encounter one bug with hive.auto.convert.join, I construct a testcase so everyone can reproduce it(or you can reach the testcase ...
Wzc1989
Aug 8, 2013 at 7:32 pm
Sep 25, 2013 at 9:23 pm -
Thanks a lot Mikhail for getting back. That means I cannot use this using beeline unless I change the code and build hive again ? Thanks sanjay From: Mikhail Antonov <<span class="m_body_email_addr" ...
Sanjay Subramanian
Aug 24, 2013 at 1:25 am
Aug 24, 2013 at 3:24 pm -
Hello All, Sorry for not replying to the thread, but I never received any of your responses.. Hopefully this info will help: @kulkarni.swarnim Here is the error I'm getting on task tracker for the ...
Jim Colestock
Aug 22, 2013 at 12:17 pm
Aug 23, 2013 at 5:45 pm -
I noticed that NPath appears to be included in Hive-0.11 but I can't find any documents explaining how to use it. Has anyone successfully used the NPath module and would be willing to share the ...
Justin Workman
Aug 16, 2013 at 6:40 pm
Aug 19, 2013 at 7:31 pm -
hi all when i use hive hive job make only one mapper actually my file split 18 block my block size is 128MB and data size 2GB i use lzo compression and create file.lzo and make index file.lzo.index i ...
闫昆
Aug 21, 2013 at 9:17 am
Aug 22, 2013 at 3:42 am -
Hi, Currently, we use TEXTFILE format in hive 0.8 ,while creating the external tables in intermediate processing . I have read about ORC in 0.11. I have created the same table in 0.11 with ORC ...
Pandees waran
Aug 12, 2013 at 10:40 am
Aug 13, 2013 at 3:54 am -
I have a table that currently uses RC files and has two levels of partitions. day and source. The table is first partitioned by day, then within each day there are 6-15 source partitions. This makes ...
John Omernik
Aug 10, 2013 at 3:57 pm
Aug 10, 2013 at 6:33 pm -
Hi, We are using DISTRIBUTE BY with custom reducer scripts in our query workload. After upgrade to Hive 0.11, queries with GROUP BY/DISTRIBUTE BY/SORT BY and custom reducer scripts produced incorrect ...
Pala M Muthaia
Aug 24, 2013 at 12:36 am
Aug 26, 2013 at 7:03 pm -
When is it expect to support lead/lag/first_value/last_value in the npath result statement? Thanks Sent from my iPhone
Justin Workman
Aug 21, 2013 at 5:44 am
Aug 22, 2013 at 1:27 am -
Views should theoretically not incur performance penalties: they simply represent queries. Are there situtions that things are "not that simple" - i.e. views may actually result in different ...
Stephen Boesch
Aug 20, 2013 at 11:16 pm
Aug 21, 2013 at 2:56 am -
Hi again, CREATE TABLE test (a INT); EXPLAIN SELECT DENSE_RANK() OVER (PARTITION BY a), a FROM test; this minimal example fails with: FAILED: SemanticException Failed to breakup Windowing invocations ...
Lars Francke
Aug 9, 2013 at 1:41 pm
Aug 20, 2013 at 2:27 am -
Hi folks, FAILED: Error in metadata: MetaException(message:file:/user/hive/warehouse/src is not a directory or unable to create one) drwxrwxrwx - hadoop supergroup 0 2013-08-16 18:31 ...
Ankit Bhatnagar
Aug 16, 2013 at 7:04 pm
Aug 17, 2013 at 1:08 am -
Hi, I am facing the same issue as mentioned in the below JIRA: https://issues.apache.org/jira/browse/HIVE-3872 I am using amazon EMR with hive 0.11. Do i need to apply any patch on top of 0.11 to fix ...
Pandees waran
Aug 7, 2013 at 1:09 pm
Aug 11, 2013 at 5:42 am -
It appears a bit challenging to find the BNF's for the hive DDL's. After a few google's the following popped up for cdh3 and only for a subset of table creation's ...
Stephen Boesch
Aug 25, 2013 at 8:38 pm
Aug 26, 2013 at 4:30 am -
What's the best way to enforce a single output file per partition? INSERT OVERWRITE TABLE <table PARTITION (x,y,z) SELECT ... FROM ... WHERE ... It tried adding CLUSTER BY x,y,z at the end thinking ...
Igor Tatarinov
Aug 20, 2013 at 9:30 pm
Aug 21, 2013 at 8:20 pm -
Hi, I was facing a weird issue with hive today. I ran the following 2 queries query1: select co.city from company1 co inner join customer1 cu on (co.city=cu.city); query2: select distinct co.city ...
Chandraprakash Bhagtani
Aug 1, 2013 at 9:42 am
Aug 13, 2013 at 7:54 am -
I have three tables: Table 1: record when and who visited gas station or not, this contains all the users of interest, name all the users as a set A date | user name | visited gas station? 2013-09-01 ...
Qiaoresearcher
Aug 30, 2013 at 11:34 pm
Sep 3, 2013 at 6:06 pm -
Hi All: Put some debugging code in TUGIContainingTransport.getTransport() and I tracked it down to @Override public TUGIContainingTransport getTransport(TTransport trans) { // UGI information is not ...
Agateaaa
Aug 29, 2013 at 5:58 pm
Aug 29, 2013 at 9:40 pm -
I love how you can "apt-get install hadoop-hive" in Ubuntu, and "brew install hive" in Mac. Could we submit a Chocolatey <http://chocolatey.org/ package for Windows, so that they can easily install ...
Andrew Pennebaker
Aug 26, 2013 at 6:22 pm
Aug 27, 2013 at 12:18 pm -
Hi everyone, I have a CDH4 cluster running In 4 nodes. I can perform queries in Beeswax UI but If I try to perform the same query with the hive console it is not possible. I launched the console in ...
Guillermo Alvarado
Aug 22, 2013 at 6:55 pm
Aug 27, 2013 at 4:12 am -
Thanks Ashutosh From: Ashutosh Chauhan <<span class="m_body_email_addr" title="ec0e9b42f0b7cae09d28ed33bc88bdbb" hashutosh@apache.org</span Reply-To: "<span class="m_body_email_addr" ...
Sanjay Subramanian
Aug 20, 2013 at 11:00 pm
Aug 21, 2013 at 10:11 pm -
HI, I see the SUM(double_column) displays the result in scientific notation in the hive cli. Is there any way to customize the number display in hive CLI? -- Thanks, Pandeeswaran Hi, I am seeing the ...
Pandees waran
Aug 13, 2013 at 6:31 am
Aug 13, 2013 at 7:48 pm -
Hi, If i run a hive query like "select * from table_name limit 10" it is working.If i run query like "select column_name from table_name limit 10" it hangs. Total MapReduce jobs = 1Launching Job 1 ...
Manickam P
Aug 6, 2013 at 9:53 am
Aug 7, 2013 at 7:31 pm -
Hi All- I was hoping to gather some insight in how the hadoop (and or hive) job scheduler distributes mappers per user. I am running into an issue where I see that hadoop (and or hive) is evenly ...
Brad Ruderman
Aug 30, 2013 at 4:38 pm
Aug 30, 2013 at 6:02 pm -
Hi all , Can we perform arithmetic operator on *select* command. I have a table emp_table with columns emp_name and emp_no i want to multiply the data in a emp_no with 10 . i tryed select * from ...
Sandeep Nemuri
Aug 22, 2013 at 2:14 pm
Aug 23, 2013 at 6:03 am -
Once again, I am down on my knees humbling calling upon the Hive Jedi Masters to please provide this paadwaan with cwiki update privileges May the Force be with u Thanks sanjay From: Sanjay ...
Sanjay Subramanian
Aug 14, 2013 at 10:53 pm
Aug 21, 2013 at 3:55 pm -
Hi everyone, Consider following DDL: CREATE TABLE partition_test (a INT) PARTITIONED BY (b INT); ALTER TABLE partition_test ADD PARTITION (b=1) location '/tmp/test1' PARTITION (b=2) location ...
Jan Dolinár
Aug 15, 2013 at 5:51 am
Aug 20, 2013 at 11:27 pm -
Hi everybody, I faced a strange error in Hive today. I have launch a hive script to make some calculations, joins, union, etc... and then insert these results in over hive table. Everything is ...
Jérôme Verdier
Aug 14, 2013 at 12:35 pm
Aug 19, 2013 at 7:19 am -
Hello, I am running Hortonworks 1.2 using Hadoop 1.1.2.21 and Hive 0.10.0.21. I set up LZO compression and can read LZO compressed data without problems. My next try was to test output compression ...
W00t w00t
Aug 13, 2013 at 9:27 am
Aug 14, 2013 at 2:33 am -
Hi, The hive thrift service is not running continously. I had to execute the command (hive --service hiveserver &) very frequently . Can any one help me on this? Thanks, Raj
Raj Hadoop
Aug 5, 2013 at 4:29 pm
Aug 6, 2013 at 6:47 pm -
Suppose we have 2 simple tables A id int value string B id When hive translates the following query select max(A.value), A.id from A join B on A.id = A.id group by A.id; It launches 2 stages, one for ...
Chen Song
Aug 1, 2013 at 5:20 pm
Aug 2, 2013 at 5:33 pm -
I'm facing issues while building an index on multiple columns in a Hive(0.9.0) table. describe nas_comps; OK leg_id int ds_name string dep_date string crr_code string flight_no string orgn string ...
Omkar Joshi
Aug 1, 2013 at 5:42 am
Aug 2, 2013 at 3:03 pm -
In PIG I am doing query like this: sdp1 = load 'db1.table1' using org.apache.hcatalog.pig.HCatLoader; sdp = FILTER sdp1 BY key1=='value1' AND key2=='value2'; ll = LIMIT sdp 100; dump ll; and hcatalog ...
Michał Czerwiński
Aug 27, 2013 at 5:42 pm
Aug 28, 2013 at 6:43 pm -
Adding user list. Any objections to removing LIKE support from getPartitionsByFilter? -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is ...
Sergey Shelukhin
Aug 27, 2013 at 2:49 am
Aug 27, 2013 at 5:36 pm -
hi all when exec hive query throw exception as follow I donnot know where is error log I found $HIVE_HOME/ logs not exist Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks not ...
闫昆
Aug 22, 2013 at 2:15 am
Aug 22, 2013 at 4:48 am -
Hi - I just started to get my feet wet with Hive and have a question that I have not been able to find an answer to.. Suppose I have 2 CSV files: Name, Address, Phone Chris, address1, 999-999-9999 ...
Chris Driscol
Aug 21, 2013 at 2:25 pm
Aug 21, 2013 at 7:02 pm -
Hi, Is hive 0.11 faster on YARN? What am I missing out if I am using hive 0.11 on MRv1 ? Thanks a lot :) - Austin
Austin Chungath
Aug 20, 2013 at 9:33 am
Aug 20, 2013 at 5:11 pm -
hi,all: i have a problem ,i have a hive table ,it source data based on HDFS,and i want to get part query result for processing(the whole data is huge,so must load partly),any good suggestions? (hive ...
Ch huang
Aug 19, 2013 at 3:17 am
Aug 19, 2013 at 11:29 pm -
the limit cause has no offset option,how to page result query by hive?
Ch huang
Aug 19, 2013 at 2:47 am
Aug 19, 2013 at 4:45 am -
Hi everybody, I want to build an application with Hadoop. I want to know which is the best way to comunicate my GUI (Django based) with Hive. I have a CDH4 cluster running, I need to perform queries ...
Guillermo Alvarado
Aug 14, 2013 at 10:45 pm
Aug 16, 2013 at 12:00 am -
I am sorry if I am missing something very basic with hive authorization on 0.9 or before. I went through the existing security in hive, before hiveserver2 (i.e. hove 0.9 or before) and I see all the ...
Rob Paul
Aug 13, 2013 at 12:31 am
Aug 15, 2013 at 1:03 am -
1) Did you miss the first word? ("NULL if A or B is NULL") 2) Darren Yin posted a similar message to the user ...
Lefty Leverenz
Aug 10, 2013 at 12:02 am
Aug 11, 2013 at 8:22 pm -
Hi, Before the advent of windowing and analytical functions in 0.11, we depend on UDAF for achieving the desired analytical functionality in 0.8, So, I would like to replace the UDAF with the ...
Pandees waran
Aug 11, 2013 at 11:23 am
Aug 11, 2013 at 12:46 pm -
Hive version: 0.10.0-cdh4.2.1 Trying to insert into a bucketized table from the same table, throws exception: "FAILED: SemanticException [Error 10122]: Bucketized tables do not support INSERT INTO ...
Neha Sood
Aug 29, 2013 at 9:03 am
Aug 29, 2013 at 9:46 am -
I created an external table and have been inserting data into it for some time. I would now like to add a partitions to the table, is this possible? thanks,George
Babe Ruth
Aug 27, 2013 at 7:12 pm
Aug 27, 2013 at 7:57 pm -
Hi, What are the key areas we need to check in the explain plan generated in Hive? I have checked the documentation, it's not detailed about the above question ...
Pandees waran
Aug 23, 2013 at 5:29 am
Aug 23, 2013 at 3:10 pm
Group Overview
group | user |
categories | hive, hadoop |
discussions | 96 |
posts | 364 |
users | 117 |
website | hive.apache.org |
117 users for August 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)