Grokbase › Groups › Hive › user › May 2014
FAQ

Hive > user > May 2014

Search Discussions

73 discussions - 203 posts

  • 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 HaldarShouvanik 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 AroraShushant 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 DevSoftware 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 ALSHABANIAmjad 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 ...
    SreenathSreenath
    May 22, 2014 at 6:23 am
    May 22, 2014 at 6:55 am
  • Sarfraz RamaySarfraz 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, SathishValluri, 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 IFTISSENMatouk 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 HaldarShouvanik 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 ShahPremal 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 GargAshish 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 ThomasSanthosh 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 ThakurArchit 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 BowmanBenjamin 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 ALSHABANIAmjad 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 ChanneRahul 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 JeffreyBryan 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 VyasJay 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 ZengJohn 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 huangCh 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 YuAzuryy 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 kantChandra 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 YangJack 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 VishwakarmaChhaya 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 JeffreyBryan 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 GuptaLeena 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 MachlinDima 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)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 MohajerianPeyman 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 AroraShushant 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õiAleksei 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 kumarKishore 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 GargAshish 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 NayakBiswajit 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 ChadnovPavel 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 ChanneRahul 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 MachlinDima 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 ThomasSanthosh 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 hbaseuserHbaseuser 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 ZengJohn Zeng
    May 19, 2014 at 10:55 pm
    May 21, 2014 at 5:56 pm
  • Hari RajendhranHari Rajendhran
    May 21, 2014 at 4:24 pm
    May 21, 2014 at 5:43 pm
  • regards, Andrew
    Xia, JunluanXia, 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 .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 EderLukas 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 ...
    SreenathSreenath
    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 ReinartzFabian 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.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)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 ChadnovPavel Chadnov
    May 29, 2014 at 11:04 pm
    May 29, 2014 at 11:04 pm
May 2014
12
Group Navigation
period‹ prev | May 2014 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions73
posts203
users90
websitehive.apache.org

90 users for May 2014

Edward Capriolo: 8 posts Bryan Jeffrey: 7 posts Shouvanik Haldar: 6 posts John Zeng: 6 posts Lefty Leverenz: 6 posts Shengjun Xin: 6 posts Sreenath: 6 posts Archit Thakur: 5 posts Ashish Garg: 5 posts Dima Machlin: 5 posts Santhosh Thomas: 5 posts Shushant Arora: 5 posts Java8964: 4 posts Premal Shah: 4 posts Rahul Channe: 4 posts Sarfraz Ramay: 4 posts Software Dev: 4 posts Thejas Nair: 4 posts Valluri, Sathish: 4 posts Amjad ALSHABANI: 3 posts
show more
Archives