FAQ

Search Discussions

94 discussions - 288 posts

  • The Apache Hive PMC has voted to make Eugene Koifman a committer on the Apache Hive Project. Please join me in congratulating Eugene! Thanks. - Carl
    Carl SteinbachCarl Steinbach
    Sep 12, 2014 at 10:35 pm
    Sep 13, 2014 at 1:52 pm
  • Hi, I have a requirement in Hive to remove duplicate records ( they differ only by one column i.e a date column) and keep the latest date record. Sample : Hive Table : d2 is a higher cno,sqno,date ...
    Raj HadoopRaj Hadoop
    Sep 10, 2014 at 5:08 pm
    Sep 11, 2014 at 2:33 pm
  • Hello, How do i get permission or add comments to pages in hive wiki? Mainly i would like to edit https://cwiki.apache.org/confluence/display/Hive/Parquet and add that hive has native support for ...
    Pratik khadloyaPratik khadloya
    Sep 19, 2014 at 5:07 pm
    Sep 22, 2014 at 5:43 am
  • Hive version 0.9 and later has a bug While inserting in a hive table Hive takes an exclusive lock. But if table is partitioned , and insert is in dynamic partition , it will take shared lock on table ...
    Shushant AroraShushant Arora
    Sep 20, 2014 at 12:39 pm
    Sep 23, 2014 at 7:24 pm
  • Dear All Am developing a prototype of syncing tables from mysql to Hive using python and JDBC. Is it a good idea using the JDBC for this purpose. My usecase will be generating the sales report using ...
    Muthu PandiMuthu Pandi
    Sep 3, 2014 at 4:46 am
    Sep 6, 2014 at 1:54 pm
  • Hi Guys, I Hive .13 for this conversion: select cast('2999-12-31 23:59:59' as timestamp) I get: 1830-11-23 00:50:51.580896768 up to around year 2199 it works fine, the work around is to convert the ...
    Peyman MohajerianPeyman Mohajerian
    Sep 10, 2014 at 9:38 pm
    Oct 21, 2014 at 9:59 pm
  • hi All, I am trying to install oozie and getting following error. Any input is appreciated [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] ...
    Rahul ChanneRahul Channe
    Sep 24, 2014 at 5:53 pm
    Sep 25, 2014 at 5:07 pm
  • To Whomsoever It May Concern, I posted this question last week but still haven't heard from anyone; I'd appreciate any reply. I've got a table that contains a LocationId field. In some cases, where a ...
    Viral ParikhViral Parikh
    Sep 15, 2014 at 11:16 am
    Sep 15, 2014 at 2:30 pm
  • Hi I have a only 604 rows in the hive table. while using A = LOAD 'revenue' USING org.apache.hcatalog.pig.HCatLoader(); DUMP A; it starts spouting heart beat repeatedly and does not leave this ...
    Amit DuttaAmit Dutta
    Sep 9, 2014 at 10:55 pm
    Sep 11, 2014 at 7:46 pm
  • Hi everyone, I have a question regarding CHD5 and Hive0.13. Looks like CDH has no plan to include Hive-on-Tez in CDH, but I like CDH in general. So my question is, can I run Apache Hive 0.13 on top ...
    James YuJames Yu
    Sep 2, 2014 at 10:06 pm
    Sep 5, 2014 at 6:23 pm
  • Hi, I am executing a mapreduce program with hcatalog and hive database. Even if the jars are included its showing this error: Exception in thread "main" java.io.IOException ...
    Poorvi AhirwalPoorvi Ahirwal
    Sep 23, 2014 at 11:12 am
    Sep 24, 2014 at 5:06 am
  • Hi, My company has been working on a Yarn application for a couple of years-- we essentially take the place of MapReduce and split our data and processing ourselves. One of the things we've been ...
    Nathan BamfordNathan Bamford
    Sep 3, 2014 at 12:26 am
    Sep 4, 2014 at 3:07 pm
  • Hello, Is it possible to create an external table without specifying the columns? In fact, I am creating an external table that points to a directory that contains 3 text file, and each text file has ...
    CHEBARO AbdallahCHEBARO Abdallah
    Sep 4, 2014 at 12:45 pm
    Sep 4, 2014 at 1:25 pm
  • I am doing a dynamic partition load in Hive 0.13 using ORC files. This has always worked in the past both with MapReduce V1 and YARN. I am working with Mesos now, and trying to trouble shoot this ...
    John OmernikJohn Omernik
    Sep 9, 2014 at 4:03 pm
    Oct 7, 2014 at 7:05 pm
  • Nathalie, Can you grab a heapdump at the time the server crashes (export this to your environment: HADOOP_CLIENT_OPTS="-XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=<give-your-path-here ...
    Vaibhav GumashtaVaibhav Gumashta
    Sep 25, 2014 at 7:52 am
    Oct 6, 2014 at 9:32 pm
  • Hi All, I have a query that attempts to computer percentiles on some datasets that are well in excess of 100,000,000 rows and have thus opted to use percentile_approx as we are routinely overrunning ...
    Kevin WeilerKevin Weiler
    Sep 25, 2014 at 7:07 pm
    Oct 2, 2014 at 6:30 pm
  • Hi, We just upgraded from hive 0.11.0 to 0.13.0 (finally!!) So I noticed that for hive-exec jar, guava is packaged in the jar v/s previously it wasn't. Any reason it is package now ? Secondly, is ...
    Viral BajariaViral Bajaria
    Sep 26, 2014 at 11:00 pm
    Sep 30, 2014 at 11:09 pm
  • Hi, what should be the configuration for hive.metastore.uris in hive-site.xml. Giving the default port and host doesnot works. Thanks, Poorvi
    Poorvi AhirwalPoorvi Ahirwal
    Sep 29, 2014 at 7:22 am
    Sep 29, 2014 at 5:03 pm
  • Hello! I'm trying to schedule a sqoop import with Oozie but when I run the job I get the given error message: -Stdout: 4219 [main] WARN org.apache.sqoop.tool.SqoopTool - $SQOOP_CONF_DIR has not been ...
    Thiago Henrique dos Santos BentoThiago Henrique dos Santos Bento
    Sep 10, 2014 at 2:15 pm
    Sep 29, 2014 at 3:36 pm
  • Hi: I'm using hive0.11, When I run a sql with 2 union all, hive client throw exception:Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at ...
    SunwwSunww
    Sep 28, 2014 at 7:48 am
    Sep 29, 2014 at 2:14 am
  • Hi , My MapReduce program takes almost 10 minutes to finish the job after it reaches map 100% reduce 100% .. Thanks Karthik
    KarthiksrivasthavaKarthiksrivasthava
    Sep 24, 2014 at 4:15 am
    Sep 28, 2014 at 6:39 pm
  • Hi All, I am using oracle as hive metastore. I could see the schema created in oracle after logging into hive and executing create database command successfully. When i am trying to create table in ...
    Rahul ChanneRahul Channe
    Sep 22, 2014 at 5:48 pm
    Sep 23, 2014 at 6:38 pm
  • Hi All, I'm new to hive. I'm having some problems querying an hive table with JDBC. It fails when it is trying to run an map reduce job. It can't seem to find the serde jar file. When I query it ...
    Shiang LuongShiang Luong
    Sep 23, 2014 at 5:28 am
    Sep 23, 2014 at 6:13 pm
  • Hi All, I have a requirement to view the recently executed Hive queries in sql. I have configured sql as metastore to hive and im able to view hive tables,columns,partitions in sql . Simillarly,i ...
    Siva kumarSiva kumar
    Sep 19, 2014 at 10:31 am
    Sep 22, 2014 at 4:08 pm
  • Hi, I would like to know how to handle frequent updates to bucketed tables. Is there a way to update without a rebuild ? I have a monthly partition for a table with buckets. But I have to update the ...
    Kumar VKumar V
    Sep 18, 2014 at 3:58 pm
    Sep 18, 2014 at 7:40 pm
  • I need a table partitioned by country and then city . I created a table and INSERTed data from another table using dynamic partition. CREATE TABLE invoice_details_hive _partitioned(Invoice_Id ...
    anusha Manginaanusha Mangina
    Sep 8, 2014 at 11:48 pm
    Sep 11, 2014 at 10:00 am
  • I wrote a UDTF in hive 0.13, the function parse a column which is json string and return a table. The function compiles successfully by adding hive-exec-0.13.0.2.1.2.1-471.jar to classpath, however ...
    Echo LiEcho Li
    Sep 8, 2014 at 11:44 pm
    Sep 10, 2014 at 8:22 am
  • Hi All, How indexes in hive are different than partitions? both improves query performance as per my knowledge then in what way they differ? What are the situations I'll be using indexing or ...
    Chhaya VishwakarmaChhaya Vishwakarma
    Sep 8, 2014 at 10:27 am
    Sep 10, 2014 at 4:06 am
  • Greetings all - We really want to look into the Parquet file format more, however, without supporting all the Hive Column types, we are hesitant to dive in more. Currently, it looks like it's just ...
    John OmernikJohn Omernik
    Sep 6, 2014 at 3:19 pm
    Sep 9, 2014 at 7:21 pm
  • My Table has Dynamic Partitions and creates the File Path as s3://some-bucket/pageviews/dt=20120311/key=ACME1234/site= example.com/Output-file-1 Is there something i can do so i can have the path ...
    anusha Manginaanusha Mangina
    Sep 9, 2014 at 3:27 pm
    Sep 9, 2014 at 6:20 pm
  • Hi all, I have few questions with regards to nested columns in Hive. the nested fields stored as separate columns or is the whole struct is serialized as one column? In general, is there a ...
    Abhishek AgarwalAbhishek Agarwal
    Sep 8, 2014 at 1:17 pm
    Sep 9, 2014 at 7:56 am
  • Hello, We are using Hive 0.11 connecting to it via Hive Thrift server 2. A lot of our queries are launching map red local tasks, which is good and expected. Since we are firing queries in parallel, ...
    Abhilash L LAbhilash L L
    Sep 6, 2014 at 6:38 am
    Sep 7, 2014 at 4:59 am
  • I have a table defined as: CREATE TABLE foo ( id INT, start_time STRING, name STRING, value STRING, type STRING ) The 'name', 'value' and 'type' fields actually describe another object, and I'd like ...
    anusha Manginaanusha Mangina
    Sep 3, 2014 at 8:48 pm
    Sep 3, 2014 at 9:09 pm
  • Hi, kindly Unsubscribe me. for the following Ids. Thanks Sridevi
    Sri kripaSri kripa
    Sep 30, 2014 at 6:03 am
    Sep 30, 2014 at 2:22 pm
  • Hi, I have '|' delimited file where arrays are serialized with square brackets. I am trying create a hive table to parse this file. Example: first|[1,2,3]|100 second|[11,12,13]|200 Create External ...
    Ankita BakshiAnkita Bakshi
    Sep 23, 2014 at 1:12 am
    Sep 23, 2014 at 2:54 pm
  • Hi, I am executing a mapreduce program with hcatalog and hive database. Even if the jars are included its showing this error: Exception in thread "main" java.io.IOException ...
    Poorvi AhirwalPoorvi Ahirwal
    Sep 23, 2014 at 7:07 am
    Sep 23, 2014 at 7:18 am
  • Whenever I am running a hive query - select * from table. It is running fine. But when i m trying to run a MR job for query - select count(*) from table. It is failing with the following error - ...
    Knowledge gathererKnowledge gatherer
    Sep 21, 2014 at 10:06 am
    Sep 23, 2014 at 2:51 am
  • My output file part-r-0000 at hive/warehouse/path/to/output_table_name/part-r-0000 has following content inside emp1_id emp1_name emp1_salary emp1_address emp1_dob emp1_joiningdate emp2_id emp2_name ...
    anusha Manginaanusha Mangina
    Sep 18, 2014 at 7:36 pm
    Sep 20, 2014 at 2:27 pm
  • Hi guys, A slightly off-topic question, but not sure where to ask. Have you ever ran TPC-DS queries over Tez ? If yes, do they work using tpcds_text_* databases as well ? Running tpch- queries work ...
    Grandl RobertGrandl Robert
    Sep 17, 2014 at 10:45 pm
    Sep 18, 2014 at 5:53 pm
  • Hi all, What is the best way to remove non-ascii characters in Hive? I found this thread from over a year ago ...
    Charles RobertsonCharles Robertson
    Sep 17, 2014 at 8:34 am
    Sep 17, 2014 at 9:05 pm
  • Hi Hive developers, I am new to hive. Yesterday i installed apache hive-0.9.0 and start executing some basics command and i found one abnormal behavior in select* command. In select statement after * ...
    SivasakthiSivasakthi
    Sep 16, 2014 at 6:29 am
    Sep 17, 2014 at 2:25 am
  • Hello, Is it possible to create an index on table stored as ORC and compressed as Snappy? Does it make sense? I am wondering if Hive indexing is a mature functionality? Thanks, Alain
    Alain PetrusAlain Petrus
    Sep 6, 2014 at 4:11 pm
    Sep 6, 2014 at 4:20 pm
  • Hi, How I create a table with this structure ? The separte are , comma, There are fields with "xx" date and "yyy" with value. 70268503,"2012-09-28 15:00:59",0,",01","18,01",,1,"2012-10-01 ...
    Ricardo Pompeu FerrerasRicardo Pompeu Ferreras
    Sep 4, 2014 at 4:44 pm
    Sep 4, 2014 at 5:29 pm
  • I'm sure this is a classpath issue but where? I am getting started with hive 0.13.1. Hadoop 2.4.0 is up and running. I installed hive from a tarball and followed the directions. But when it came time ...
    Geoffry RobertsGeoffry Roberts
    Sep 2, 2014 at 6:22 pm
    Sep 3, 2014 at 2:56 pm
  • I had text file on HDFS, then I created tables in Hive, and loaded these data to the tables. When I dropped the tables, the data was lost. Any idea why? Thanks ******************************* This ...
    CHEBARO AbdallahCHEBARO Abdallah
    Sep 2, 2014 at 3:16 pm
    Sep 2, 2014 at 3:48 pm
  • Hi Hive Users: I have a hive generic hive udf which is called protect_column. The udf works fine when I call it along. But when I run the following query: select case when id = 5 then ...
    Dan FanDan Fan
    Sep 24, 2014 at 6:42 pm
    Oct 7, 2014 at 7:23 am
  • Hi All I am trying to test the transaction feature, especially compaction of Hive 0.13. I am getting a nullpointer exception at ...
    SupriyaSupriya
    Sep 25, 2014 at 8:54 am
    Oct 2, 2014 at 5:47 pm
  • Hello, We are using Hive 0.12. While using WebHCat, I stumbled upon a problem regarding the name of tables. We generate table names according to Hive’s documentation : “ In Hive 0.12 and earlier, ...
    Charles BonneauCharles Bonneau
    Sep 26, 2014 at 10:18 am
    Sep 26, 2014 at 9:55 pm
  • Hi, I am unable to start service hiveserver2 on windows. I am starting this service to configure ODBC connection to Excel. I am issuing the following command to start the service: It is not throwing ...
    Praveen BaalebailPraveen Baalebail
    Sep 18, 2014 at 8:23 am
    Sep 25, 2014 at 7:56 am
  • How do I suppress deprecated INFO on hive startup? -bash-4.1$ hive 14/09/24 05:58:16 INFO Configuration.deprecation: mapred.input.dir.recursive is deprecated. Instead, use ...
    Manoj PrasadManoj Prasad
    Sep 24, 2014 at 10:55 pm
    Sep 25, 2014 at 1:02 am
Group Navigation
period‹ prev | Sep 2014 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions94
posts288
users114
websitehive.apache.org

114 users for September 2014

Lefty Leverenz: 10 posts Nitin Pawar: 10 posts Anusha suryadevara: 9 posts Nishant Kelkar: 9 posts Pratik khadloya: 8 posts Xuefu Zhang: 8 posts CHEBARO Abdallah: 7 posts Muthu Pandi: 7 posts Poorvi Ahirwal: 7 posts Rahul Channe: 7 posts Amit Dutta: 6 posts Furcy Pin: 6 posts Shushant Arora: 6 posts Alain Petrus: 5 posts Hadoop hive: 5 posts John Omernik: 5 posts Peyman Mohajerian: 5 posts Raj Hadoop: 5 posts Vaibhav Gumashta: 5 posts Praveen Baalebail: 4 posts
show more
Archives