FAQ

Search Discussions

65 discussions - 230 posts

  • unsuscribe
    Payal Radheshamji AgrawalPayal Radheshamji Agrawal
    Feb 18, 2015 at 7:28 am
    Feb 26, 2015 at 6:44 am
  • I am pleased to announce that Sergey Shelukhin has been elected to the Hive Project Management Committee. Please join me in congratulating Sergey! Thanks. - Carl
    Carl SteinbachCarl Steinbach
    Feb 25, 2015 at 4:44 pm
    Feb 27, 2015 at 11:44 pm
  • Perfect. Thank you Xuefu. Philippe -- Philippe Kernévez Directeur technique (Suisse), <span class="m_body_email_addr" title="50e0343d61a25dc2e8f524cc91350fd8" pkernevez@octo.com</span +41 79 888 33 ...
    Philippe KernévezPhilippe Kernévez
    Feb 1, 2015 at 7:30 pm
    Feb 22, 2015 at 2:15 am
  • Interesting discussion. It looks like the HBase metastore can also be configured to use HDFS HA (ex. tutorial ...
    Samuel MarksSamuel Marks
    Feb 1, 2015 at 1:58 am
    Feb 4, 2015 at 1:19 am
  • The Apache Hive PMC has voted to make Chao Sun, Chengxiang Li, and Rui Li committers on the Apache Hive Project. Please join me in congratulating Chao, Chengxiang, and Rui! Thanks. - Carl
    Carl SteinbachCarl Steinbach
    Feb 9, 2015 at 8:33 pm
    Feb 11, 2015 at 8:35 pm
  • Hello, How to query data by page in Hive? hive select * from u_data a limit 1,2; FAILED: ParseException line 1:31 missing EOF at ',' near '1' <span class="m_body_email_addr" ...
    R7raul1984R7raul1984
    Feb 5, 2015 at 8:01 am
    Feb 25, 2015 at 12:51 am
  • Let me introduce PL/HQL, an open source tool that implements procedural SQL on Hadoop. It is going to support all major procedural syntaxes. The tool can be used with any SQL-on-Hadoop solution ...
    Dmitry TolpekoDmitry Tolpeko
    Feb 27, 2015 at 8:37 pm
    Mar 6, 2015 at 3:24 pm
  • Hi All, I configured the oozie build successfully and prepared oozie war file. After starting oozie when i tried to checkstatus its giving following error ...
    Rahul ChanneRahul Channe
    Feb 22, 2015 at 7:52 am
    Feb 23, 2015 at 3:03 pm
  • Hi, I have a table (named DEDUPLICATED) that contains about 1 billions rows. Each day I receive a new file with about 5 millions rows. About 10% of those rows are duplicated (duplication occur inside ...
    Philippe KernévezPhilippe Kernévez
    Feb 17, 2015 at 5:33 pm
    Feb 19, 2015 at 12:35 pm
  • The Apache Hive team is proud to announce the the release of Apache Hive version 1.0.0. The Apache Hive (TM) data warehouse software facilitates querying and managing large datasets residing in ...
    Vikram Dixit KVikram Dixit K
    Feb 4, 2015 at 10:10 pm
    Feb 6, 2015 at 4:40 am
  • Hi Everyone, I am using hive 0.13! I want to find multiple tokens like "hip hop" and "rock music" in my data and replace them with "hiphop" and "rockmusic" - basically replace them without white ...
    Viral ParikhViral Parikh
    Feb 3, 2015 at 6:48 pm
    Feb 17, 2015 at 1:17 pm
  • Hey all, I was monitoring a specific JIRA for Hive (https://issues.apache.org/jira/browse/HIVE-7073) and saw that it was resolved in Hive 0.15. But now with the Hive 1.0.0 release after Hive 0.14, am ...
    John OmernikJohn Omernik
    Feb 9, 2015 at 7:44 pm
    Feb 9, 2015 at 8:48 pm
  • Hello team, I have two tables A and B. A has 360Million rows with one column K. B has around two billion rows with multiple columns including K. Both tables are clustered and sorted by K and Bucketed ...
    Murali parimiMurali parimi
    Feb 27, 2015 at 1:42 pm
    Mar 5, 2015 at 7:42 pm
  • Hi Team, Here is old thread about this issue: http://qnalist.com/questions/5091386/doubt-about-locking-mechanism-in-hive I met the same issue that when reading one table in session A, we can not ...
    Jim GreenJim Green
    Feb 26, 2015 at 1:25 am
    Feb 28, 2015 at 11:48 am
  • Hi, I am using Hive 0.14 Can any one help me on to execute the below type query insert into table emp (eid,ename) select * from dept where emp.id = dept.id *Thanks & Regards,* *Srinivas T*
    Srinivas ThungaSrinivas Thunga
    Feb 26, 2015 at 12:35 pm
    Feb 27, 2015 at 4:30 am
  • Hi, I have an application using hive, and just upgraded from 0.13.1 to 0.14.0. However, a bunch of unit testcases, which are using embedded derby metastore, failing to drop table. Here are the ...
    Jie ZhangJie Zhang
    Feb 23, 2015 at 7:05 am
    Feb 24, 2015 at 4:19 am
  • the parquet spec about logical types and Timestamp specifically, seems to say https://github.com/Parquet/parquet-format/blob/master/LogicalTypes.md "TIMESTAMP_MILLIS is used for a combined logical ...
    YangYang
    Feb 3, 2015 at 12:16 am
    Feb 19, 2015 at 9:14 pm
  • Unsubscribe
    Himanshu VijayHimanshu Vijay
    Feb 4, 2015 at 10:29 pm
    Feb 17, 2015 at 4:18 pm
  • Hi All, How all of you are creating hive/Impala table when the CSV file has some values with COMMA in between. it is like sree,12345,"payment made,but it is not successful" I know opencsv serde is ...
    SreemanSreeman
    Feb 13, 2015 at 4:20 am
    Feb 13, 2015 at 7:29 pm
  • If I were to transfer a table from existing oracle to hive, I'd find it impossible with NUMBER type columns. By default oracle NUMBER gives 38 bits, but hive's closest counterpart is the DECIMAL , ...
    YangYang
    Feb 21, 2015 at 3:37 pm
    Feb 24, 2015 at 9:21 pm
  • According to the release note of Hive 1.0.0, the HiveServer1 is removed. Can we still use command line in 1.0.0? -- Thanks, Dayong
    DU DUDU DU
    Feb 9, 2015 at 4:55 pm
    Feb 9, 2015 at 5:30 pm
  • Hello all, We are excited to announce that a new stable version of Hivemall (v0.3.0) is now available. https://github.com/myui/hivemall/releases/tag/v0.3.0 Hivemall provides a collection of machine ...
    Makoto YuiMakoto Yui
    Feb 6, 2015 at 11:32 am
    Feb 9, 2015 at 5:12 am
  • Hi, My Hive jdbc client queries ( hiveserver2) to secured cluster fails with below exception after one or two days running fine from tomcat. Any idea what might be the issue? Is it a known issue? ...
    Bogala, Chandra ReddyBogala, Chandra Reddy
    Feb 25, 2015 at 11:47 am
    Feb 26, 2015 at 9:46 am
  • Hi, I'm a bit stuck in optimizing the hive/tez config parameters to speed up Hive/Tez query execution. The cluster consists of 6 worker nodes (with rather hadoop-non-ideal component proportion, but ...
    Gerd KönigGerd König
    Feb 25, 2015 at 8:06 am
    Feb 25, 2015 at 3:15 pm
  • When querying a hive table according to a partitioning column, it would be logical that a simple select count(distinct partitioned_column_name) from my_partitioned_table would complete almost ...
    Stephen BoeschStephen Boesch
    Feb 24, 2015 at 6:27 am
    Feb 24, 2015 at 6:39 am
  • Hi everyone, I see that Hive on Tez dynamically chooses the number of tasks to launch for each vertex in the generated DAG according to cluster load (other than data size). For research purposes I'd ...
    Fabio C.Fabio C.
    Feb 19, 2015 at 9:48 am
    Feb 20, 2015 at 7:51 am
  • I have a unix time that I need to convert time-zones and then do some calculations on it. In the end I want to create a fractional hour (15:30 - 15.5). We are at Hive 0.14.0.2.2.0.0-2041 I have the ...
    Craig JonesCraig Jones
    Feb 18, 2015 at 7:07 pm
    Feb 18, 2015 at 8:16 pm
  • I'm using hive-0.13.1 (hdp-2.1.5) Hiveserver2 is running for 6 days nobody is connected to the server now. last connection was 30 min ago. Used memory: 688MB (after GC) Live threads: 297 perm: 99.6% ...
    Alexander PivovarovAlexander Pivovarov
    Feb 5, 2015 at 3:59 am
    Feb 6, 2015 at 8:29 pm
  • I'm wondering if predicates are pushed down when they apply to elements of a nested struct. More specifically, imagine a table such as CREATE TABLE t ( c1 int, c2 STRUCT<a:int,b:int ) STORED as XXX ...
    The WatcherThe Watcher
    Feb 5, 2015 at 6:30 pm
    Feb 5, 2015 at 7:58 pm
  • Hi everybody, I want to add support for reading Hive-managed data to Apache Flink and have a question regarding the overlap of HCatalog and Hive metastore. Is it sufficient to add support for ...
    Fabian HueskeFabian Hueske
    Feb 4, 2015 at 10:14 am
    Feb 4, 2015 at 7:45 pm
  • Hi Everyone Can I get write access to hive wiki? I need to put descriptions for several UDFs added recently (init_cap, add_months, last_day, greatest, least) Confluence username: apivovarov ...
    Alexander PivovarovAlexander Pivovarov
    Feb 2, 2015 at 10:15 pm
    Feb 3, 2015 at 12:24 am
  • Hi I am migrating my hive from CDH4 to CDH5(1.2), I had a udf that extracts the useragent values out of the useragent string, I am using the third-party uadetector library, This UDF worked well in ...
    Guy DoulbergGuy Doulberg
    Feb 2, 2015 at 3:52 pm
    Feb 2, 2015 at 5:11 pm
  • Hi, we occasionally run into a BindException causing long running jobs to occasionally fail. The stacktrace is below. Any ideas what this could be caused by? Cheers, Krishna Stacktrace: 379969 ...
    Krishna RaoKrishna Rao
    Feb 26, 2015 at 4:19 pm
    Feb 28, 2015 at 3:23 pm
  • I'm working on defining a custom InputFormat and OutputFormat for use with Hive. I'd like tables using these IF/OF to be native tables, so that I can LOAD DATA and INSERT INTO them. However, I'm ...
    Luke LovettLuke Lovett
    Feb 19, 2015 at 6:10 pm
    Feb 25, 2015 at 5:15 pm
  • I am using hive from HDP 2.2 and need to create a Hive table to query multilevel Json data in HDFS of the following format: { "timestamp": "1424100629409", "head": { "time" ...
    Udit MehtaUdit Mehta
    Feb 23, 2015 at 6:30 pm
    Feb 24, 2015 at 6:53 am
  • I'm using hive 0.13. What are the maximum number of hive tables allowed? what are the maximum number of partitions? For example, if I had 100k tables, each with 20k partitions should I expect any ...
    Anish KejariwalAnish Kejariwal
    Feb 22, 2015 at 11:54 pm
    Feb 23, 2015 at 1:24 am
  • I created a parquet file, expose that to hive using an external table, but select from such tables are always giving NULL. to show the symptom, I created the following data set , each record has only ...
    YangYang
    Feb 19, 2015 at 7:32 pm
    Feb 19, 2015 at 9:14 pm
  • Hi, I am using JDBC Client to create Function in hive (Ex. IFNULL) , it works only for database for which I created. If I want to use the same Function in another database, i need to create once ...
    Vengatesh.babuVengatesh.babu
    Feb 18, 2015 at 4:04 am
    Feb 18, 2015 at 8:56 am
  • Hi, Newbie and trying to do some custom script. Not exactly hive related, so kindly bear When I run hadoop fs -ls, I get below output [root@node3 conf]# hadoop fs -ls <path 14/06/10 11:29:32 INFO ...
    Baveja, AnkushBaveja, Ankush
    Feb 18, 2015 at 7:24 am
    Feb 18, 2015 at 8:12 am
  • Hello! I have csv files which are small in size which are moved to the HDFS using the SequenceFile Format. The key is the file name and contents of the file becomes the value. Now I want to create an ...
    Varsha RaveendranVarsha Raveendran
    Feb 13, 2015 at 4:59 pm
    Feb 15, 2015 at 11:50 am
  • Hi all, I'm using HCatWriter in a java program to write records to a partitioned Hive table. It works great, but I notice it leaves behind the _SCRATCH directories it uses for staging (before ...
    Nathan BamfordNathan Bamford
    Feb 13, 2015 at 9:51 pm
    Feb 13, 2015 at 10:32 pm
  • I'm hoping someone else has had this problem. I tried searching, but couldn't find anything ... I'm running Hive Version 0.13.1 on EMR I have data files staged externally in s3 in the following ...
    Joshua EldridgeJoshua Eldridge
    Feb 2, 2015 at 4:42 pm
    Feb 11, 2015 at 8:50 am
  • Hi folks, I got following errors in Hive 1.0.0. However, I can run them successfully in Hive 0.13.0 and 0.14.0. Is this a big? Are there any workaround? --Create Index in either type COMPACT or ...
    DU DUDU DU
    Feb 9, 2015 at 7:47 pm
    Feb 9, 2015 at 8:44 pm
  • Currently using Hive 13.x Would like to select from a table that exists and output to an external file(s) in avro via hive. Is there a simple way to do this? From what I’ve seen online, the docs tend ...
    Michael SegelMichael Segel
    Feb 2, 2015 at 1:10 pm
    Feb 2, 2015 at 1:17 pm
  • Hello I would like to generate predicates in the ExprNodeDesc form, as required by the HiveStoragePredicateHandler.decomposePredicate ...
    Gabriel balanGabriel balan
    Feb 26, 2015 at 5:02 pm
    Feb 26, 2015 at 5:02 pm
  • Hi, I am trying to use a signed jar (BouncyCastle) in one of my UDFs. Since signed jars shouldn't be extracted I am using two ADD JAR statements to add both the UDF jar as well as BouncyCastle ...
    Rahul SharmaRahul Sharma
    Feb 26, 2015 at 7:03 am
    Feb 26, 2015 at 7:03 am
  • Hi Everyone Lets say I have a table partitioned by period string how to select max period? if I run select max(period) from invoice; hive 0.13.1 runs MR which is slow OK STAGE DEPENDENCIES: Stage-1 ...
    Alexander PivovarovAlexander Pivovarov
    Feb 25, 2015 at 8:11 pm
    Feb 25, 2015 at 8:11 pm
  • Hi everyone, Consider the sql : SELECT thumbnail( product_ image ) FROM advert i sements WHERE product_name = ‘ Brownie’ ; The product_ image field is a reference to a multi-megabyte image object ...
    R7raul1984R7raul1984
    Feb 25, 2015 at 6:37 am
    Feb 25, 2015 at 6:37 am
  • Hi, This might've been asked previously but I couldn't find any examples of how to query uniontype in Hive. I have this field in the table: `location` ...
    Buntu DevBuntu Dev
    Feb 24, 2015 at 6:44 pm
    Feb 24, 2015 at 6:44 pm
  • Dear all, I am running HiveServer2(0.14). Java Heap Memory keeps on increasing for failed Queries. Below Jira looks pretty same. https://issues.apache.org/jira/browse/HIVE-7021 They have given patch ...
    Vengatesh.babuVengatesh.babu
    Feb 23, 2015 at 3:52 pm
    Feb 23, 2015 at 3:52 pm
Group Navigation
period‹ prev | Feb 2015 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions65
posts230
users100
websitehive.apache.org

100 users for February 2015

DU DU: 13 posts Srinivas Thunga: 13 posts Alexander Pivovarov: 11 posts Devopam Mittra: 10 posts Yang: 9 posts Lefty Leverenz: 8 posts Jadhav Shweta: 7 posts R7raul1984: 7 posts Philippe Kernévez: 6 posts Xuefu Zhang: 6 posts Alan Gates: 5 posts Samuel Marks: 5 posts Vaibhav Gumashta: 5 posts Rahul Channe: 4 posts Guy Doulberg: 3 posts John Omernik: 3 posts Prasanth Jayachandran: 3 posts Szehon Ho: 3 posts Biswajit Nayak: 2 posts Bogala, Chandra Reddy: 2 posts
show more
Archives