Grokbase › Groups › Hive › user › March 2014
FAQ

Hive > user > March 2014

Search Discussions

87 discussions - 270 posts

  • Hi, We have some files stored in MongoDB , mostly in key value format. We need to parse those files and store it into Hive tables. Any inputs on this will be appreciated. Thanks, Swagatika
    Swagatika TripathySwagatika Tripathy
    Mar 26, 2014 at 4:59 pm
    Apr 1, 2014 at 8:25 am
  • Im running hive from inside of maven, and am getting a weird exception: tate,fname,lname,hash(product) from cleaned1395942132407 Total MapReduce jobs = 3 Launching Job 1 out of 3 Number of reduce ...
    Jay VyasJay Vyas
    Mar 27, 2014 at 5:44 pm
    Mar 28, 2014 at 5:16 pm
  • Hey everyone, before i write a lot of text, i just post something which is already written: http://www.sqlservercentral.com/Forums/Topic1328496-360-1.aspx The first posts adresses a pretty similar ...
    Fab wolFab wol
    Mar 5, 2014 at 1:17 pm
    Mar 19, 2014 at 12:52 pm
  • Hi , I have a table that has a partition column partition_hr . Data Type is int (partition_hr int) . When i run a sort on this column the output is like this. 1 10 11 12 13 14 15 16 17 18 19 2 20 21 ...
    Arafat, MoizArafat, Moiz
    Mar 11, 2014 at 1:21 pm
    Mar 14, 2014 at 4:15 pm
  • Hi All, We have installed CDH4.2.0 and hive-0.10.0-cdh4.2.0. Both are working as desired. We need to set hive configuration parameter from Java while making JDBC connection. We have written a java ...
    Garg, RinkuGarg, Rinku
    Mar 4, 2014 at 11:44 am
    Mar 10, 2014 at 3:00 am
  • Hey everyone, I have a table with currently 5541 partitions. Daily there are 14 partitions added. I will switch the update for the metastore from "msck repair table" to "alter table add partition", ...
    Fab wolFab wol
    Mar 27, 2014 at 9:02 am
    Mar 27, 2014 at 10:37 pm
  • Hello, We are using Hive to query S3 data. For one of our tables named analyze, we generate data hierarchically. First level of hierarchy is date and second level is a field named *generated_by* ...
    Saumitra Shahapure (Vizury)Saumitra Shahapure (Vizury)
    Mar 25, 2014 at 10:52 am
    Mar 25, 2014 at 5:30 pm
  • Is there a way to read Hive Map datatype without knowing keys? According to Hive document, the only way to read a Map is to access through keys, ie: myMap['myKey']. However, in many cases, the keys ...
    Frank LuoFrank Luo
    Mar 17, 2014 at 10:06 pm
    Mar 18, 2014 at 3:06 pm
  • Hi, I'm trying to get the following query to work. The parser don't like it. Anybody aware of a workaround? SELECT * FROM mytable WHERE partitionCol IN my_udf("2014-03-10"); partitionCol is my ...
    Petter von Dolwitz (Hem)Petter von Dolwitz (Hem)
    Mar 10, 2014 at 3:23 pm
    Mar 11, 2014 at 2:22 pm
  • Hi all, I'm trying to implement a udf which makes use of some data structures like binary tree. However, it seems that hive instantiates new udf object for each row in the table. Then the data ...
    Sky880883368Sky880883368
    Mar 24, 2014 at 4:34 pm
    Mar 26, 2014 at 1:57 am
  • Hi, I have a bunch of data already in place in a directory on HDFS containing many different logs of different types, so I'm attempting to load these externally like so: CREATE EXTERNAL TABLE mylogs ...
    OliverOliver
    Mar 24, 2014 at 3:18 pm
    Mar 25, 2014 at 3:21 pm
  • I have a table with 10 million rows and 2 columns - id (int) and element (string). I am trying to do a self join that finds any ids where the element values are the same, and my query looks like ...
    Jeff StoreyJeff Storey
    Mar 20, 2014 at 2:04 pm
    Mar 20, 2014 at 11:03 pm
  • I have an input file in Sequence File format which has the format, <length of value <value which has the type <IntWritable <Text Then I created a table, CREATE TABLE if not exists TEST ( value ...
    Kim ChewKim Chew
    Mar 8, 2014 at 1:27 am
    Mar 10, 2014 at 8:40 pm
  • Hello everyone, The HiveThrift Service was started succesfully. netstat -nl | grep 10000 tcp 0 0 0.0.0.0:10000 0.0.0.0:* LISTEN I am able to read tables from Hive through Tableau. When executing ...
    Raj HadoopRaj Hadoop
    Mar 20, 2014 at 7:10 pm
    Mar 20, 2014 at 9:52 pm
  • Hi, Is it possible to write data to a local file system using Hive server 2 ? When I use 'insert overwrite local directory /tmp/hivedata ...............', it writes data in the directory on the box ...
    Kumar VKumar V
    Mar 14, 2014 at 12:43 pm
    Mar 17, 2014 at 6:40 pm
  • Hello everyone, I'm running Hive 0.12.0 and I thought that support for moving tables between database was added by using ALTER TABLE RENAME TO fully qualified name. Here is what I executing; ALTER ...
    Clay McDonaldClay McDonald
    Mar 13, 2014 at 1:09 pm
    Mar 14, 2014 at 2:34 pm
  • I want to convert a table to a bucketed table, so I made a new table with the same schema as the old table and specified a cluster column: create table foo_bucketed ( a string, b int, c float ) ...
    Keith WileyKeith Wiley
    Mar 7, 2014 at 7:47 pm
    Mar 8, 2014 at 3:45 am
  • Query in HIVE I tried merge kind of operation in Hive to retain the existing records and append the new records instead of dropping the table and populating it again. If anyone can come help with any ...
    Raj hadoopRaj hadoop
    Mar 6, 2014 at 8:30 am
    Mar 6, 2014 at 9:16 am
  • Without mapping /mounting the hbase table , how can I access and query hbase table ?
    Manju MManju M
    Mar 31, 2014 at 7:12 pm
    Apr 1, 2014 at 3:47 am
  • Hi folks. I'm trying to wrap my head around the latest Hive architecture (as of 0.12 at least). From what I've gathered: - HiveServer2 is the new Thrift based Hive server. - We can use Thrift, JDBC, ...
    Uber SlackerUber Slacker
    Mar 28, 2014 at 3:29 pm
    Mar 28, 2014 at 5:06 pm
  • How can i scan one day's data from Hbase table and insert that into Hbase partition ( date) ? is it possible?
    Manju MManju M
    Mar 28, 2014 at 6:34 am
    Mar 28, 2014 at 9:09 am
  • My join query is failing. Any suggestions on how I should troubleshoot this? 92651139753_0036_1_conf.xml to ...
    Clay McDonaldClay McDonald
    Mar 24, 2014 at 6:08 pm
    Mar 24, 2014 at 9:01 pm
  • Hi, I'm testing out the REST interface to webhcat and stuck doing basic DDL operations. Background on installation: --I installed packages with apt-get --I'm on CDH4.5 I successfully have created and ...
    Adam SilbersteinAdam Silberstein
    Mar 14, 2014 at 5:01 pm
    Mar 19, 2014 at 7:14 pm
  • Hi all, I've tried BigTop test for join_filters: CREATE TABLE myinput1(key int, value int); LOAD DATA LOCAL INPATH 'seed_data_files/in3.txt' INTO TABLE myinput1; where seed_data_files/in3.txt: 12 35 ...
    Martin KudlejMartin Kudlej
    Mar 12, 2014 at 1:47 pm
    Mar 13, 2014 at 1:03 am
  • Hi, I have a table in hive which has data of three months old. I have partitioned the data and I got 90 partitions. Now when I get the new data from next day I want to replace the partition 1week old ...
    Kasi SubrahmanyamKasi Subrahmanyam
    Mar 6, 2014 at 10:24 am
    Mar 6, 2014 at 2:38 pm
  • Hi team, following query hangs at 99.97% for one reducer, kindly help or point to what can be cause drop table if exists sample.dpi_short_lt;create table sample.dpi_short_lt asselect b.msisdn, ...
    Siddharth TiwariSiddharth Tiwari
    Mar 2, 2014 at 11:09 pm
    Mar 5, 2014 at 8:23 pm
  • Hi, I have implemented a few custom input formats in Hive. It seems like only the getRecordReader() method of these input formats is being called though, i.e. there is no way of overriding the ...
    Petter von Dolwitz (Hem)Petter von Dolwitz (Hem)
    Mar 3, 2014 at 2:14 pm
    Mar 5, 2014 at 6:01 am
  • I am trying to use the php hive thift client and there is name space and autoload issues. Autoload is not generated and I have not found any instructions how to properly generate it. Also some files ...
    JeremyJeremy
    Mar 17, 2014 at 5:46 pm
    Apr 23, 2014 at 6:07 pm
  • Hello All, I have tow tables created in Hive, one read the data immidiately from Cassandra DB and the other takes the data from stored files (data already exported in somewhow from the same Cassandra ...
    Amjad ALSHABANIAmjad ALSHABANI
    Mar 28, 2014 at 11:17 am
    Mar 28, 2014 at 1:27 pm
  • Hello, I'm trying to convert managed partitioned text table into compressed orc partitioned table. I created the a new table with the same schema but when I try inserting data the errors says there ...
    P lvaP lva
    Mar 26, 2014 at 3:19 pm
    Mar 26, 2014 at 8:37 pm
  • We use Hive-0.12 and are planning to use HiveServer2 with cloudera Hue. The scenario is like this. There are frequent additions of Hive UDFs by users and this requires frequent Hive deployment. To ...
    Ashu PachauriAshu Pachauri
    Mar 11, 2014 at 11:57 pm
    Mar 24, 2014 at 9:28 pm
  • Hi All I am trying to query External Hive Table created on hbase ( hbase table is compressed using "gzip") . I am getting quick response, if I use "select * from hbase_acct_pref_dim_", but the query ...
    Sunil RankaSunil Ranka
    Mar 19, 2014 at 6:43 pm
    Mar 22, 2014 at 2:47 am
  • I'm executing a hive query in which one of the fields an array and writing it to a file using: INSERT OVERWRITE '/path/to/output' SELECT ... This query works well. I would like to load this data into ...
    Jeff StoreyJeff Storey
    Mar 21, 2014 at 12:38 pm
    Mar 21, 2014 at 1:19 pm
  • Hello, I'm having trouble with loading data into a table with a dynamic partition with custom field delimiters. When I use tabs, it works, when I have fields delimited by '001' it does not. I'm using ...
    Nurdin PremjiNurdin Premji
    Mar 18, 2014 at 6:46 pm
    Mar 19, 2014 at 6:27 am
  • Hi, I'm using hive (with external tables) to process data stored on amazon S3. My data is partitioned as follows: DIR s3://test.com/2014-03-01/ DIR s3://test.com/2014-03-02/ DIR ...
    Sherine BrisillalSherine Brisillal
    Mar 11, 2014 at 7:28 am
    Mar 11, 2014 at 10:54 am
  • Hi, I import data from CVS files into an external ORC table. I don't have error when using those external table. Then I import those table into ORC Table. When I execute some requests I have ...
    Philippe KernévezPhilippe Kernévez
    Mar 6, 2014 at 7:08 pm
    Mar 7, 2014 at 3:42 pm
  • Hi, Help required to merge data in hive, Ex: Today file ------------- Empno ename 1 abc 2 def 3 ghi Tomorrow file ----------------- Empno ename 5 abcd 6 defg 7 ghij Reg: should not drop the hive ...
    Raj hadoopRaj hadoop
    Mar 5, 2014 at 12:17 pm
    Mar 6, 2014 at 5:50 am
  • All, I loaded data from an Oracle query through Sqoop to HDFS file. This is bzip compressed files partitioned by one column date. I created a Hive table to point to the above location. After loading ...
    Raj HadoopRaj Hadoop
    Mar 4, 2014 at 10:24 pm
    Mar 4, 2014 at 10:36 pm
  • Hello All, I have a use case in RDBMS query which I have implemented in HIVE as.. *1.1) Update statement* *in RDBMS* update TABLE1 set Age= case when isnull(age,'') ='' then 'A= Current' else '240+ ...
    Yogesh dhariYogesh dhari
    Mar 4, 2014 at 6:46 am
    Mar 4, 2014 at 5:38 pm
  • Hi All, I have a scenario where i have to load data into a hive table from a csv file. But the csv file is in a remote system. I am planning to use ftp to transfer the file to the system where hive ...
    Vishnu ViswanathVishnu Viswanath
    Mar 4, 2014 at 5:04 am
    Mar 4, 2014 at 7:59 am
  • Congrats Xuefu! -- Lefty
    Lefty LeverenzLefty Leverenz
    Mar 1, 2014 at 5:38 am
    Mar 3, 2014 at 6:02 pm
  • Hi Team, I am seeing following error in hive in reduce phase,can you guide me on its cause and possible solution ? java.lang.RuntimeException: Hive Runtime Error while closing operators: Unable to ...
    Siddharth TiwariSiddharth Tiwari
    Mar 1, 2014 at 9:03 am
    Mar 2, 2014 at 2:50 am
  • Hi, Could somebody grant me write access to the Hive wiki? I'd like to update some outdated information on the Hive Tutorial<https://cwiki.apache.org/confluence/display/Hive/Tutorial page. My Apache ...
    Anthony HsuAnthony Hsu
    Mar 31, 2014 at 5:03 pm
    Mar 31, 2014 at 5:08 pm
  • hi,maillist: i find sometime hive drop table will take long time ,why? Time taken: 0.994 seconds hive (default) drop table t2; OK Time taken: 60.661 seconds hive (default) drop table t3; OK Time ...
    Ch huangCh huang
    Mar 31, 2014 at 3:03 am
    Mar 31, 2014 at 5:06 am
  • I have a join query where i am joining huge tables and i am trying to optimize this hive query. INSERT OVERWRITE TABLE result SELECT /*+ STREAMTABLE(product) */ i.IMAGE_ID, p.PRODUCT_NO, p.STORE_NO, ...
    Srinivasan RamaswamySrinivasan Ramaswamy
    Mar 26, 2014 at 10:55 pm
    Mar 28, 2014 at 10:01 am
  • Are there any good documents on this? - Its easy to run hive in totally local JDBC with the 1.2 tarball, but its almost impossible it seems to run it with the 2.x hadoop tarballs. It seems like its ...
    Jay VyasJay Vyas
    Mar 27, 2014 at 10:28 pm
    Mar 27, 2014 at 10:58 pm
  • Hi all, I have a table 'tabname' which has a field 'deleteDate' with type BIGINT.There are records with NULL value in this field.I want to retrieve all those records. But when I execute Query, select ...
    Rishabh BhardwajRishabh Bhardwaj
    Mar 27, 2014 at 6:28 am
    Mar 27, 2014 at 6:46 am
  • Hi, Can you please help me in finding bulid.xml for installation of hive. I used following link for installation *https://cwiki.apache.org/confluence/display/Hive/AdminManual+Installation ...
    Nagarjuna VissarapuNagarjuna Vissarapu
    Mar 25, 2014 at 3:42 pm
    Mar 25, 2014 at 5:16 pm
  • Hello. Is there a firm release date for Hive 13? I know there was talk several weeks ago about cutting a branch and looking at stability. Regards, Bryan Jeffrey
    Bryan JeffreyBryan Jeffrey
    Mar 19, 2014 at 1:51 pm
    Mar 21, 2014 at 6:15 pm
  • just a public service announcement. I had a case where i had a nested json array in a string and i needed that to act like a first class array in hive. natively, you can pull it out but it'll just a ...
    Stephen SpragueStephen Sprague
    Mar 12, 2014 at 9:21 pm
    Mar 18, 2014 at 12:18 pm
Mar 2014
12
Group Navigation
period‹ prev | Mar 2014 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions87
posts270
users96
websitehive.apache.org

96 users for March 2014

Stephen Sprague: 21 posts Nitin Pawar: 17 posts Navis류승우: 13 posts Fab wol: 9 posts Java8964: 9 posts Szehon Ho: 8 posts Manju M: 7 posts Jeff Storey: 6 posts Jeremy: 6 posts Petter von Dolwitz (Hem): 6 posts Siddharth Tiwari: 6 posts Chinna Rao Lalam: 5 posts Clay McDonald: 5 posts Jay Vyas: 5 posts Raj hadoop: 5 posts Raj Hadoop: 5 posts Rishabh Bhardwaj: 5 posts Arafat, Moiz: 4 posts Garg, Rinku: 4 posts Kim Chew: 4 posts
show more
Archives