Search Discussions
-
Hi, Does anybody help urgently on optimizing hive query performance? I am looking more Hadoop tuning point of view. Currently, small amount of table takes much time to query? We are running EMR ...
Shouvanik Haldar
May 30, 2014 at 10:06 pm
Jun 1, 2014 at 10:43 pm -
I have used a configuration property 'hive.cache.expr.evaluation' in hive 0.12 recently and found it useful. But I cannot find any documents about it on the wiki page ...
郭士伟
May 24, 2014 at 8:02 am
Jul 17, 2014 at 3:07 pm -
Hi I have a requirement to transfer data from RDBMS mysql to partitioned hive table Partitioned on Year and month. Each record in mysql data contains timestamp of user activity. What is the best tool ...
Shushant Arora
May 1, 2014 at 1:44 pm
May 2, 2014 at 1:23 pm -
We have a table with user entered queries, their IP. How could we write a query that will count and order queries by their count having a unique IP count X. For example if we had the same IP enter ...
Software Dev
May 29, 2014 at 11:30 pm
Jun 6, 2014 at 6:05 pm -
Hello Everybody, I know that this question may concern Hadoop list but i ve made this mistake when using Hive. I created new database giving the location on HDFS but i found that it removed all other ...
Amjad ALSHABANI
May 30, 2014 at 10:11 am
Jun 2, 2014 at 5:50 pm -
Hi All, We are running a hadoop cluster and many of our hive queries are failing in the reduce phase with the following error java.io.IOException: All datanodes *.*.*.*:50230 are bad. Aborting... at ...
Sreenath
May 22, 2014 at 6:23 am
May 22, 2014 at 6:55 am -
Sarfraz Ramay
May 1, 2014 at 12:47 pm
May 3, 2014 at 6:14 pm -
Hi, I have an Hive table created with 3 different union data types for alias_host column name as shown. (array<string ,string, null). CREATE EXTERNAL TABLE array_tests ROW FORMAT SERDE ...
Valluri, Sathish
May 29, 2014 at 10:42 am
Jun 4, 2014 at 2:42 am -
Hé Geeks, Is there a best manner to load or read data in hive table (normal or external) from plural subdirectories? exemple : I have a directory my_directory and in there are lot of subdirectory ...
Matouk IFTISSEN
May 14, 2014 at 10:12 am
May 27, 2014 at 11:28 am -
Hi, I need help in finding how long a map-reduce job runs. Any help is highly appreciated. Thanks, Shouvanik This message is for the designated recipient only and may contain privileged, proprietary, ...
Shouvanik Haldar
May 20, 2014 at 4:36 pm
May 20, 2014 at 5:06 pm -
I have a table in hive stored as text file with 3283 columns. All columns are of string data type. I'm trying to convert that table into an orc file table using this command *create table orc_table ...
Premal Shah
May 16, 2014 at 1:08 pm
May 19, 2014 at 8:50 pm -
Can you try to fix this problem? I have a local file called mytest.txt (restored in hdfs already). The content is like this: $ cat -A HDFSLOAD_DIR/mytest.txt 49139801^A25752451^Aunknown$ ...
Ashish Garg
May 29, 2014 at 11:27 pm
May 30, 2014 at 5:16 am -
Hello I am writing an application that detects new table creation in hive. I came across attribute ' hive.metastore.event.listeners' in hive-default.xml, but could not find any usage samples. The API ...
Santhosh Thomas
May 20, 2014 at 7:46 am
May 20, 2014 at 11:00 am -
Hi, I am facing few problems while using Tez on Hive. I am able to run Tez through YARN submitting independent MR procesing job. Also, when I run SELECT query on hive shell by setting *set ...
Archit Thakur
May 11, 2014 at 12:37 pm
May 14, 2014 at 9:52 am -
Hive 0.13 & Hadoop 2.4 I am having an issue when using the combination of vectorized query execution, BETWEEN, and a custom UDF. When I have vectorization on, my query returns an empty set. When I ...
Benjamin Bowman
May 30, 2014 at 12:25 pm
May 30, 2014 at 7:47 pm -
Hello everybody, I m trying to start hiveserver2 to connect to hive via a PHP application, but in the same time I would like to keep connecting Hive CLI ( hive ) on the same machine to execute some ...
Amjad ALSHABANI
May 28, 2014 at 8:42 am
May 28, 2014 at 11:03 am -
I have created the following partitioned table in hive create table custs ( cust_id int, first_name String,last_name String,cust_age int ) partitioned by ( cust_prof String) row format delimited ...
Rahul Channe
May 20, 2014 at 2:02 am
May 21, 2014 at 12:38 am -
All, I am executing the following query using Hadoop 2.2.0 and Hive 0.13.0. /opt/hadoop/latest-hive/bin/beeline -u jdbc:hive2://server:10002/database -n root --hiveconf ...
Bryan Jeffrey
May 16, 2014 at 1:58 pm
May 17, 2014 at 2:57 am -
Hi hive. Is there an API akin to PigServer, which allows you to run a hive script from Java directly, using hive embedded mode, without use of JDBC? -- Jay Vyas http://jayunit100.blogspot.com
Jay Vyas
May 16, 2014 at 6:04 pm
May 17, 2014 at 1:57 am -
Hi, All, I created a ORC table by doing this: add jar /home/dguser/hive-0.12.0/lib/hive-exec-0.12.0.jar; CREATE TABLE orc_UserDataTest2( PassportNumbers1 STRING, PassportNumbers2 STRING, TaxID ...
John Zeng
May 11, 2014 at 3:16 pm
May 16, 2014 at 10:38 pm -
hi,maillist: i try hive 0.12,but it always run job in local mode ,why? i install hive on a seperate hox ,and install hadoop client on it ,and configure the client connect to my hadoop cluster hive ...
Ch huang
May 12, 2014 at 7:54 am
May 13, 2014 at 1:48 am -
Hi, I downloaded hive-0.13, but how to specify the hadoop version using maven? I cannot find document. Thanks.
Azuryy Yu
May 6, 2014 at 8:55 am
May 11, 2014 at 6:13 am -
Hi, When running bin/hive , i get the following error :- Exception in thread "main" java.lang.IncompatibleClassChangeError: Found interface jline.Terminal, but class was expected at ...
Chandra kant
May 6, 2014 at 3:34 am
May 6, 2014 at 3:39 pm -
Hi All, I have a local file called mytest.txt (restored in hdfs already). The content is like this: $ cat -A HDFSLOAD_DIR/mytest.txt 49139801^A25752451^Aunknown$ 49139801^A24751754^Aunknown$ ...
Jack Yang
May 18, 2014 at 5:25 am
May 29, 2014 at 11:38 pm -
Hi, I have connected SAP BO to Hive using a ODBC driver. I am able to see the database and table in hive. but when i fetch data from hive it gives error as org.apache.hadoop.hìve.serde2.SerDeExceptio ...
Chhaya Vishwakarma
May 20, 2014 at 4:59 am
May 20, 2014 at 5:58 am -
All, We are running Hadoop 2.2.0 and Hive 0.13.0. One typical application is to load data (as text), and then convert that data to ORC to decrease query time. When running these processes we are ...
Bryan Jeffrey
May 16, 2014 at 11:12 pm
May 19, 2014 at 2:56 pm -
Hi, I'm trying to create a function that generates a UUID, want to use it in a query to insert data into another table. Here is the function: package com.udf.example; import java.util.UUID; import ...
Leena Gupta
May 16, 2014 at 1:44 pm
May 17, 2014 at 1:57 am -
Hi, Starting the metastore (Hive 0.12) service there is a WARNING [main] WARN bonecp.BoneCPConfig: Max Connections < 1. Setting to 20 What does this setting mean? Max connections from hive servers to ...
Dima Machlin
May 14, 2014 at 1:46 pm
May 16, 2014 at 7:25 pm -
Hi I need a help in resolving a data load issue with Hive. Background: I am testing the Informatica connectivity with Big data ( Hadoop and Hive). I have installed HDFS 1.0.3 and Hive 0.7.1 in RHEL ...
Muthukumar Somasundaram (ETS)
May 12, 2014 at 8:06 am
May 13, 2014 at 10:46 am -
I have stopped receiving any email from this list!
Peyman Mohajerian
May 11, 2014 at 12:48 am
May 11, 2014 at 7:01 pm -
I have a hive table in which data is populated from RDBMS on daily basis. After map reduce each mapper write its data in hive table partitioned at month level. Issue is daily when job runs it fetches ...
Shushant Arora
May 5, 2014 at 10:04 am
May 6, 2014 at 4:37 am -
Hello, There is this old recommendation for optimizing Hive join to use the largest table last in the join. http://archive.cloudera.com/cdh/3/hive/language_manual/joins.html The same recommendation ...
Aleksei Udatšnõi
May 2, 2014 at 12:36 pm
May 5, 2014 at 10:46 pm -
Hi Experts, How to change the non partitioned table into partitioned table in hive. I created a table with create table table_name1(col1 type, col2 type.......) row format fields terminated by '|' ...
Kishore kumar
May 2, 2014 at 1:19 pm
May 2, 2014 at 2:51 pm -
Hello all, Can we create the partitioned table in managed table and can we specify the location other than default warehouse directory? If yes, then what is the benefit of external table. Is it just ...
Ashish Garg
May 31, 2014 at 4:48 am
May 31, 2014 at 9:01 pm -
Hi All, I had metastore(0.12) running previously. But after upgrading to 0.13 it is failing with below error message. The upgrade was a clean new setup. Additional details:- Mysql Version:- 5.6 Mysql ...
Biswajit Nayak
May 21, 2014 at 11:29 am
May 30, 2014 at 6:14 pm -
Hello, I'm trying to make sure that unit tests are passed on my local machine for Hive 0.13 but for ql module I get a java.lang.ClassNotFoundException: com.mysql.jdbc.Driver. I'm running the tests ...
Pavel Chadnov
May 29, 2014 at 5:45 pm
May 29, 2014 at 5:48 pm -
Hi All, I am trying to login to HIVE and getting following error user@localhost:~$ hive 14/05/28 16:42:04 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no longer has any effect. Use ...
Rahul Channe
May 28, 2014 at 8:45 pm
May 28, 2014 at 9:03 pm -
Hi all, It seems that for some reason HS2 outputs far less logging than HS1 in hive 0.12 for example, starting HS1 in the following way : hive --service hiveserver and executing show tables produces ...
Dima Machlin
May 21, 2014 at 2:07 pm
May 25, 2014 at 10:54 am -
I am trying to find the creation time of a table using table.createTime() function. I was hoping that it returns the time in milli seconds, but looks like it is not. Any idea how to get the actual ...
Santhosh Thomas
May 22, 2014 at 5:20 am
May 22, 2014 at 5:31 am -
Hi, I'm trying to process JSON data in hive (0.12) with "\n" inside some of the keys & values. It is messed up and I have no control over changing the input. What is the best way to process this data ...
Hbaseuser hbaseuser
May 21, 2014 at 10:48 pm
May 21, 2014 at 11:09 pm -
Hi, All, I noticed ‘nextColumnsBatch’ is marked as ‘Deprecated’ in RCFile.Reader class. What is the method that will replace ‘nextColumnsBatch’? And why? Thanks John
John Zeng
May 19, 2014 at 10:55 pm
May 21, 2014 at 5:56 pm -
Hari Rajendhran
May 21, 2014 at 4:24 pm
May 21, 2014 at 5:43 pm -
regards, Andrew
Xia, Junluan
May 17, 2014 at 12:28 pm
May 17, 2014 at 10:04 pm -
hi all, I am new to hive install and configuration. I have given the task of install/configure Hive (HIVE 012.0 tar file from apache HIVE site) to work with a remote hadoop master node (namenode and ...
MrAsanjar .
May 17, 2014 at 2:33 pm
May 17, 2014 at 9:55 pm -
Hello, We were approached to add support for Hive SQL in jOOQ [1], which might be useful for a greater community in general. I've gone through the Hive SQL syntax and I've encountered this ...
Lukas Eder
May 13, 2014 at 9:58 am
May 16, 2014 at 6:53 pm -
Hi all, Is there a way in hive by which i can redirect the output of a query to some folder that already has some data. I know 'INSERT OVERWRITE DIRECTORY' but this overwrites the existing content ...
Sreenath
May 14, 2014 at 12:22 pm
May 14, 2014 at 12:22 pm -
I implemented a MapReduce job with HCatalog as input and output. It's pretty much the same as the example on the website. If I start my job with `hadoop jar` an initial MapReduce is performed (which, ...
Fabian Reinartz
May 2, 2014 at 2:29 pm
May 3, 2014 at 1:38 am -
I ran the following command to import an excel.csv file into hbase. Everything looked ok however when I ran a scan on the table in hbase I did not see as many rows as were in excel.csv file. Any help ...
Kennedy, Sean C.
May 1, 2014 at 10:34 pm
May 1, 2014 at 10:56 pm -
Hi We want to share Yarn environment and we are using capacity scheduler. Now we want to share the same hiveserver2 also. How can we do it? Can we mention queue name in query context? Thanks ...
Natarajan, Prabakaran 1. (NSN - IN/Bangalore)
May 30, 2014 at 11:29 am
May 30, 2014 at 11:29 am -
Hello, I'm trying to run Hive unit tests on my local machine. At first Hive could not load Mysql driver (some tests for ql are failing). I put the mysql connector jar to the conf dir. It didn't help ...
Pavel Chadnov
May 29, 2014 at 11:04 pm
May 29, 2014 at 11:04 pm
Group Overview
group | user |
categories | hive, hadoop |
discussions | 73 |
posts | 203 |
users | 90 |
website | hive.apache.org |
90 users for May 2014
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)