FAQ

Search Discussions

73 discussions - 279 posts

  • Hi, Is it possible to use json_tuple function to extract data from json arrays (nested too). I am trying to process json data as string and avoid using serdes since user data may be malformed. Please ...
    Sam JoeSam Joe
    Oct 27, 2015 at 7:20 pm
    Oct 28, 2015 at 4:30 am
  • Hello! New message, please read <http://gottabesuccessful.com/sleep.php?m Allen Wittenauer
    Allen WittenauerAllen Wittenauer
    Oct 11, 2015 at 6:30 am
    Oct 25, 2015 at 11:29 am
  • Hi, I have been having some issues with loading data into hive from one table to another for 1,767,886 rows. I was getting the following error Task with the most failures(4): ----- Task ID ...
    Mich TalebzadehMich Talebzadeh
    Oct 13, 2015 at 4:32 pm
    Oct 13, 2015 at 8:44 pm
  • Hi all, I have a hiveserver2 client running on a remote server. I'm able to connect to it via beeline CLI and everything works fine but when I try to query via a JDBC client, the stdout is not ...
    Jerrick HoangJerrick Hoang
    Oct 20, 2015 at 1:04 am
    Oct 20, 2015 at 7:38 am
  • Hi, I believe my Hive version is Apache 1.2.0. I guessed it from the folder and hive-hwi.jar names. I am trying to insert values into a column of type timestamp. It does not work This is how I create ...
    AnandaVelMurugan Chandra MohanAnandaVelMurugan Chandra Mohan
    Oct 27, 2015 at 12:49 am
    Oct 29, 2015 at 4:14 am
  • Hi, What is the duration of locks held in Hive? I have got the following locks in Hive, although I have already killed the jobs! Lock ID Database Table Partition State Type Transaction ID Last ...
    Mich TalebzadehMich Talebzadeh
    Oct 23, 2015 at 7:57 am
    Oct 28, 2015 at 10:23 am
  • Hi All, I am trying to run load data inpath to update/refresh my table data in hive. I am using HiveServer2 to make jdbc connection and run the following command load data inpath ...
    Vineet MishraVineet Mishra
    Oct 20, 2015 at 12:38 pm
    Oct 27, 2015 at 4:48 pm
  • Hi all, I'm trying to connect o HiveServer2 by using beeline client, When I do `/usr/local/hive/bin/beeline -u jdbc:hive2://<hostA :9890`, I got `Error: Failed to open new session ...
    Jerrick HoangJerrick Hoang
    Oct 19, 2015 at 7:38 pm
    Oct 20, 2015 at 12:09 am
  • Hi All, I am trying to connect to HiveServer2 to query some data in parallel and landing up into some weird exception, stack trace mentioned below java.sql.SQLException: Error while cleaning up the ...
    Vineet MishraVineet Mishra
    Oct 9, 2015 at 7:54 am
    Oct 11, 2015 at 4:57 pm
  • I am using Tez 0.7.0 on Hadopp 2.6 to run Hive queries. I am interested in checking DAGs for my queries visually, and I realized that I can do that by graphviz once I can get "dot" files of my DAGs ...
    James PirzJames Pirz
    Oct 1, 2015 at 12:29 am
    Oct 1, 2015 at 6:21 pm
  • Hello, I am working on Flink and Spark majoring in Computer Science in Berlin. I have the important question. Well, this question is from what I do these days, which is translations Hive Query to ...
    Philip LeePhilip Lee
    Oct 22, 2015 at 2:22 pm
    Oct 27, 2015 at 5:49 pm
  • Hi, I have a CSV file which contains hunderd thousand rows and about 200+ columns. Some of the columns have free text information, which means it might contain characters like comma, colon, quotes ...
    Vijaya Narayana Reddy Bhoomi ReddyVijaya Narayana Reddy Bhoomi Reddy
    Oct 30, 2015 at 6:16 pm
    Nov 1, 2015 at 9:22 am
  • 1.How can i set Storage Level when i use Hive on Spark? 2.Do Spark have any intention of dynamically determined Hive on MapReduce or Hive on Spark, base on SQL features. Thanks in advance Best regards
    Jone ZhangJone Zhang
    Oct 23, 2015 at 5:32 am
    Oct 23, 2015 at 2:49 pm
  • Hello, I would like to install Hive with Spark on Windows, I've already installed Spark, but I cant find a clear documentation on how to configure hive on windows with spark. Regards -- Ing. Ivaldi ...
    Andrés IvaldiAndrés Ivaldi
    Oct 20, 2015 at 12:14 am
    Oct 20, 2015 at 4:16 pm
  • Hello, I hit a problem this morning: ./hive –service metastore Caused by: MetaException(message:Could not connect to meta store using any of the URIs provided. Most recent failure ...
    Gary ClarkGary Clark
    Oct 15, 2015 at 3:17 pm
    Oct 15, 2015 at 9:48 pm
  • Hi all, I am trying to compile hive from source, but I get the following error: [ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1:compile (default-compile) on project ...
    Giannis GiannakopoulosGiannis Giannakopoulos
    Oct 1, 2015 at 7:14 am
    Oct 2, 2015 at 5:14 pm
  • Does hive have a built in function to return a dotted-quad representation of an IP address given a network address as an integer as input? If not, does anyone have SQL they would be willing to share ...
    Mark SunderlinMark Sunderlin
    Oct 22, 2015 at 6:45 pm
    Nov 22, 2015 at 2:35 pm
  • I notice from the Hive locking wiki page <https://cwiki.apache.org/confluence/display/Hive/Locking that locks may be acquired for a range of HQL DDL operations. I wanted to know how the locking ...
    Elliot WestElliot West
    Oct 22, 2015 at 1:41 pm
    Oct 28, 2015 at 12:12 pm
  • To store the processed records I am using HiveBolt in Storm topology with following arguments. - id: "MyHiveOptions" className: "org.apache.storm.hive.common.HiveOptions" - "${metastore.uri}" # ...
    Harshit RaikarHarshit Raikar
    Oct 9, 2015 at 9:05 am
    Oct 21, 2015 at 7:28 pm
  • Congratulations Ashutosh! Thanks Carl for your contribution and leadership over the last few years! Zheng
    Zheng ShaoZheng Shao
    Oct 1, 2015 at 7:08 pm
    Oct 12, 2015 at 3:03 am
  • I’ve installed Hive 1.2.1 on Amazon Linux AMI release 2015.03, master-node of Hadoop cluster. I can successfully access the Beeline client but when I try to connect to Hive-Server2… beeline Ø ...
    Timothy GarzaTimothy Garza
    Oct 8, 2015 at 2:03 pm
    Oct 9, 2015 at 2:26 pm
  • Hi, I'd like to know the good way to do a a UDF for a single field, like SELECT tbl.id AS id, tbl.name AS name, tbl.city AS city, state_from_city(tbl.city) AS state FROM my_db.my_table tbl; *Native ...
    Daniel LopesDaniel Lopes
    Oct 1, 2015 at 1:12 pm
    Oct 1, 2015 at 5:54 pm
  • Hi all, my question is why UserGroupInformation equals method depend on the subject object? try below code which is extract from HiveMetaStore: UserGroupInformation clientUgi = null ...
    WangwenliWangwenli
    Oct 17, 2015 at 2:06 pm
    Oct 30, 2015 at 2:41 am
  • hi gurus, kindly clarify the following please - Hive currently does not support indexes or indexes are not used in the query - The lowest granularity for concurrency is partition. If table is ...
    Ashok KumarAshok Kumar
    Oct 29, 2015 at 5:43 am
    Oct 29, 2015 at 8:32 pm
  • Hi I inserted a table from select (insert into table newtable select date, hh, x, y from oldtable). After the insert the column names of the table have been removed, see the output below when I use ...
    PatchareePatcharee
    Oct 23, 2015 at 7:25 am
    Oct 23, 2015 at 2:55 pm
  • hello there, please refer to : https://commons.wikimedia.org/wiki/File:Apache_Hive_logo.jpg I had uploaded this as-is after downloading from main site, and stated the usage terms from ...
    Devopam MittraDevopam Mittra
    Oct 17, 2015 at 5:59 pm
    Oct 19, 2015 at 5:09 am
  • Hi, We are using Hive to merge small files by setting hive.merge.smallfiles.avgsize to 120000000 and doing an insert as select to a table. The problem is that this take two passes over the data, ...
    Daniel HavivDaniel Haviv
    Oct 16, 2015 at 7:48 am
    Oct 17, 2015 at 3:27 pm
  • Hello - While surfing the code in "apply" function of CalcitePlannerAction (CalcitePlanner.java), I see that most rules are passed to a HepPlanner to arrive at the "least cost" operator tree. The ...
    RaajayRaajay
    Oct 6, 2015 at 9:06 pm
    Oct 7, 2015 at 6:36 pm
  • Hi, I am trying to create a table with Regex SerDe but failing with no good reason: CREATE EXTERNAL TABLE syslog ( month STRING, day STRING, time STRING, source STRING, process STRING, pid STRING, ...
    IT CTOIT CTO
    Oct 1, 2015 at 12:17 pm
    Oct 1, 2015 at 4:51 pm
  • Hey folks, I've been working on a rather odd issue for a while now, and I'm going to need a hand here. In one field of a table, I have yaml inside the field (including \n's). Regardless of the ...
    Aaron WiebeAaron Wiebe
    Oct 23, 2015 at 6:23 pm
    Oct 23, 2015 at 9:21 pm
  • Hi, After streaming twitter data to HDFS using Flume, I'm trying to analyze it using some HIVE queries. The data is in JSON format and not clean having double quotes (") in wrong places causing the ...
    Sam JoeSam Joe
    Oct 22, 2015 at 10:02 pm
    Oct 23, 2015 at 10:12 am
  • Hi, I have some CSV data which is encompassing each field in double quotes e.g. “hello”, “”, “test”, “aaaa”. I noticed that there is a CSV Serde now available in Hive 0.14. Is it possible to use this ...
    Michael EnglandMichael England
    Oct 21, 2015 at 3:27 pm
    Oct 22, 2015 at 8:00 am
  • So I have strict mode on and I like to keep it that way. I am trying to do this query. INSERT OVERWRITE TABLE vertical_stats_recent PARTITION (dt=2015101517) SELECT ... FROM entry_hourly_v3 INNER ...
    Edward CaprioloEdward Capriolo
    Oct 15, 2015 at 9:06 pm
    Oct 20, 2015 at 6:31 am
  • We are currently using the HCatalog API to get the Hive Database metadata. HCatClient with MetaStore uri. The HCatTable object returned by the HCatClient does not have the view SQL (view ...
    Rachna Jotwani BakhruRachna Jotwani Bakhru
    Oct 14, 2015 at 11:47 pm
    Oct 15, 2015 at 8:49 pm
  • now hiveserver2 has multiple instance register to zookeeper, if zookeeper recover from fault, the znode represent the hs2 instance got deleted(eg. session timeout), the hiveserver2 will receive ...
    WangwenliWangwenli
    Oct 12, 2015 at 1:52 pm
    Oct 13, 2015 at 1:18 am
  • Hello all, The product I work on using the HCatalog api (particularly HCatClient) to interact with Hive. It provides virtually everything we need, with the exception of the ability to truncate a ...
    Nathan BamfordNathan Bamford
    Oct 6, 2015 at 7:14 pm
    Oct 12, 2015 at 8:46 pm
  • Even having enough heap size my hiveserver2 going outofmemory, I enable heap dump on error which producing 650MB of heap although I have hiveserver2 configured with 8GB Heap. here is the stacktrace ...
    Sanjeev VermaSanjeev Verma
    Oct 8, 2015 at 11:01 am
    Oct 12, 2015 at 6:38 pm
  • I am creating a table from the two parquet partioned tables and getting the error duplicate column. any idea whats going wrong here. create table sample_table AS select * from parquet_table par inner ...
    Sanjeev VermaSanjeev Verma
    Oct 12, 2015 at 7:08 am
    Oct 12, 2015 at 7:28 am
  • After long vacation, I've found my account on apache JIRA is disabled. I think I've logged in somewhere and forgot to logout or it was just hacked (shamefully -_-) Does anyone know how to address ...
    Navis RyuNavis Ryu
    Oct 7, 2015 at 7:29 am
    Oct 12, 2015 at 12:58 am
  • Hello, I have a question regarding parquet tables. We have POS data, we want to store the data on per day partition basis. We sqoop the data into an external table which is in text file format and ...
    Yogesh KeshettyYogesh Keshetty
    Oct 9, 2015 at 5:51 am
    Oct 10, 2015 at 12:57 am
  • Hi All, Do you guys see any error in the following left join sql statement? However, the hive give me error as "Error: Error while compiling statement: FAILED: SemanticException [Error 10017]: Line ...
    Garry ChenGarry Chen
    Oct 6, 2015 at 1:20 pm
    Oct 6, 2015 at 2:25 pm
  • regards Dev
    Devopam MittraDevopam Mittra
    Oct 28, 2015 at 3:38 pm
    Oct 29, 2015 at 2:53 am
  • Archit ThakurArchit Thakur
    Oct 25, 2015 at 7:42 am
    Oct 26, 2015 at 7:46 am
  • Hi, I am using alter command below to merge partitioned orc file on one partition: alter table X partition(zone=1,z=1,year=2009,month=1) CONCATENATE; - How can I control the number of files after ...
    PatchareePatcharee
    Oct 22, 2015 at 8:43 am
    Oct 23, 2015 at 3:02 pm
  • Hi, May I have access to edit the wiki? My confluence user name is 'teabot'. I've been looking briefly at ALTER TABLE CONCATENATE and noticed that the operation isn't listed on the Hive/Locking wiki ...
    Elliot WestElliot West
    Oct 22, 2015 at 9:59 am
    Oct 23, 2015 at 6:28 am
  • I have following s3 directory structure. Data/ Year=2015/ Month=01/ Day=01/ files Day=02/ files Month=02/ Day=01/ files Day=02/ files . . . Year=2014/ Month=01/ Day=01/ files Day=02/ files Month=02/ ...
    Hafiz MujadidHafiz Mujadid
    Oct 22, 2015 at 10:57 am
    Oct 22, 2015 at 6:19 pm
  • Hi all! I have seen different methods are not implemented in hive jdbc drive like getURL in hiveDatabaseMetaData class. Can somebody guide me when these methods are going to be implemented and will ...
    Hafiz MujadidHafiz Mujadid
    Oct 19, 2015 at 9:59 am
    Oct 21, 2015 at 7:11 pm
  • We are using Hive 0.14 Our input file size is around 100 GB uncompressed We are using insering this data to hive which is ORC based table , ZLIB While inserting we are also using following two ...
    Jagat SinghJagat Singh
    Oct 21, 2015 at 12:49 am
    Oct 21, 2015 at 12:59 am
  • I have a java application which reads hive metadata using hcatalog apis. If I need to read metadata from a hive database on a cluster with Kerberos and knox, would the following configuration work? ...
    Rachna Jotwani BakhruRachna Jotwani Bakhru
    Oct 16, 2015 at 1:24 am
    Oct 20, 2015 at 3:13 am
  • Hi, I have a Hive external table with a lot of partitions where the underlying data is in JSON. I use this popular serde <https://github.com/rcongiu/Hive-JSON-Serde to read and write in JSON format ...
    Udit MehtaUdit Mehta
    Oct 15, 2015 at 8:51 pm
    Oct 16, 2015 at 11:41 am
Group Navigation
period‹ prev | Oct 2015 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions73
posts279
users100
websitehive.apache.org

100 users for October 2015

Mich Talebzadeh: 14 posts Vineet Mishra: 14 posts Sean Ellis: 13 posts Jerrick Hoang: 10 posts Sam Joe: 10 posts Gopal Vijayaraghavan: 9 posts Elliot West: 8 posts Xuefu Zhang: 8 posts Alan Gates: 7 posts Ryan Harris: 7 posts Lefty Leverenz: 6 posts R7raul1984: 6 posts AnandaVelMurugan Chandra Mohan: 4 posts Daniel Haviv: 4 posts Daniel Lopes: 4 posts Devopam Mittra: 4 posts Gary Clark: 4 posts Giannis Giannakopoulos: 4 posts Jörn Franke: 4 posts Philip Lee: 4 posts
show more
Archives