Grokbase Groups Hive user August 2014
FAQ

Search Discussions

88 discussions - 265 posts

  • As my raw-data table is partitioned by date.. i want to get data to run a query every days to find top 10 products in last 15 days . How to pass list of dates dynamically as arguments in hive query ...
    karthik Srivasthavakarthik Srivasthava
    Aug 24, 2014 at 4:50 am
    Aug 31, 2014 at 5:18 pm
  • Hi all, I have a problem with IN statement in HiveQL. My table "cdr", column "calldate" which type is "date". First query is successfully return: select * from cdr where calldate = '2014-05-02'; But ...
    ilhami Kalkanilhami Kalkan
    Aug 12, 2014 at 11:23 am
    Aug 13, 2014 at 8:02 pm
  • I am using TEZ as Hive Execution Engine. When i run a query , Yarn Containers are using all the space available in node. This doesnt allow another query to run. Am i missing any configuration ...
    karthik Srivasthavakarthik Srivasthava
    Aug 16, 2014 at 3:16 pm
    Aug 20, 2014 at 11:29 pm
  • Hi All, I am trying to use MatchPath UDF (Previously called NPath). Does anybody have a document around its syntax and usage? Regards, Asif
    Muhammad Asif AbbasiMuhammad Asif Abbasi
    Aug 25, 2014 at 12:28 pm
    Sep 5, 2014 at 3:00 pm
  • Hi I have a hive (0.11) table with the following create syntax: CREATE EXTERNAL TABLE events( … ) PARTITIONED BY(dt string) ROW FORMAT SERDE 'parquet.hive.serde.ParquetHiveSerDe' STORED AS ...
    Tor IvryTor Ivry
    Aug 17, 2014 at 12:07 pm
    Aug 26, 2014 at 8:06 am
  • Hi, I have some troubles with the locking/concurrency mechanism of Hive when doing a large select and trying to create a table at the same time. My version of Hive is 0.13. What I try to do is the ...
    Sourygna LuangsaySourygna Luangsay
    Aug 22, 2014 at 12:49 pm
    Sep 18, 2014 at 3:55 am
  • Hi, Is there any way to create custom user defined data type in Hive? I want to move some table data from teradata database to Hive. But in teradata database tables, there are few columns data type ...
    Reena upadhyayReena upadhyay
    Aug 26, 2014 at 12:42 am
    Aug 26, 2014 at 5:51 am
  • Pl let me know how I can load a CSV file with embedded map and arrays data into Hive. Regards, Sushant
    Sushant PrustySushant Prusty
    Aug 19, 2014 at 9:01 am
    Aug 22, 2014 at 8:58 pm
  • HI all, I am loading some data into a Hive table, and one of the fields contains text which I believe contains new line characters. I have a view which reads data from this table, and the new line ...
    Charles RobertsonCharles Robertson
    Aug 17, 2014 at 6:20 pm
    Aug 21, 2014 at 10:56 am
  • Hello, Using Hive, we know that we should specify the file path to read data from a specific location. If the data is distributed on many computers, how can we read it? Thanks ...
    CHEBARO AbdallahCHEBARO Abdallah
    Aug 12, 2014 at 12:22 pm
    Aug 12, 2014 at 2:39 pm
  • Hi, I'm trying to submit a MapReduce job through webhcat using the templeton/v1/mapreduce/jar path. My job depends on third party libraries. I have tried a lot of things such as using the libjars ...
    Remy DuboisRemy Dubois
    Aug 6, 2014 at 5:19 pm
    Aug 7, 2014 at 3:19 pm
  • Hello, I have two table ,one is stored as textfile for loading data from local data, the other is stored as rcfile for compressing data。 when I execute the following sql two times * insert into table ...
    王洋王洋
    Aug 28, 2014 at 2:45 pm
    Aug 29, 2014 at 3:22 am
  • This question is not directly related to Hive, but: I configured 3 datanodes on my Linux machine. In my configuration, I configured the number of replication to be 1. I am submitting a file to the ...
    CHEBARO AbdallahCHEBARO Abdallah
    Aug 26, 2014 at 1:16 pm
    Aug 26, 2014 at 2:20 pm
  • Hello All, I am trying to use the ODBC driver but making ODBC Calls to fetch a list of tables from Hive is extremely slow on a HiveServer2. The cluster has a large number of tables but it takes in ...
    Charles YorekCharles Yorek
    Aug 15, 2014 at 2:55 pm
    Aug 15, 2014 at 9:03 pm
  • Hi, a very simple question: Is there a difference between a table in Hive and a table in HCat? In other words: Can I create a table in Hive that is invisible in HCat, or vice versa? (Assuming that ...
    André HackerAndré Hacker
    Aug 5, 2014 at 7:23 am
    Aug 14, 2014 at 12:23 pm
  • Hi All, I am getting following error hive show databases; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to instantiate ...
    Rahul ChanneRahul Channe
    Aug 7, 2014 at 1:14 am
    Aug 11, 2014 at 8:57 pm
  • I'm executing some queries using HiveServer2 and jdbc. Once in a while my application gets stuck with an output like this (on random query, nondeterministic): 07:24:54.910 [pool-4-thread-1] DEBUG ...
    Paweł MichnaPaweł Michna
    Aug 11, 2014 at 3:08 pm
    Aug 11, 2014 at 7:23 pm
  • I've written a small UDF and placed it in a JAR (a.jar). The UDF has a dependency on a class in another JAR (b.jar). in Hive, I do: add jar a.jar; add jar b.jar; create temporary function .....; but ...
    Brian JeltemaBrian Jeltema
    Aug 2, 2014 at 11:47 am
    Aug 4, 2014 at 5:56 pm
  • Hi team Quick question. I am writing a hive generic UDF. In which, I wanna have this: HashMap<String, String vpDefinition = new HashMap<String, String () ; vpDefinition.push(“auction_id”,”22”) ; The ...
    Dan FanDan Fan
    Aug 1, 2014 at 8:14 pm
    Aug 1, 2014 at 10:25 pm
  • Hello. (First off, sorry if I accidentally posted to the wrong mailing list before - dev - and you are getting this again) Regarding the ArrayWritableGroupConverter class: I was just wondering how ...
    Raymond LauRaymond Lau
    Aug 13, 2014 at 12:06 am
    Sep 19, 2014 at 6:34 pm
  • Hi, Can someone please tell me if there is a way to alter the precision digits for a double/float data type to 2 or 3. Eg: 232879.7979879 to 232879.79 Thanks, UPD
    Upd rUpd r
    Aug 26, 2014 at 6:25 pm
    Aug 27, 2014 at 4:40 am
  • Greetings to everyone. I am a newbie in Java and seeks guidance in learning "Java specifically required for Hadoop". It will be really helpful if someone can pass on the links/topics/online-courses ...
    Db-BlogDb-Blog
    Aug 14, 2014 at 10:31 pm
    Aug 15, 2014 at 7:10 pm
  • Hi, I am currently experimenting with using Hive for a large dataset and I am having trouble with optimising the jobs. The dataset I have is quite a large number of fairly small gzipped files, but I ...
    Ana GillanAna Gillan
    Aug 13, 2014 at 10:58 am
    Aug 13, 2014 at 7:36 pm
  • Hi! I Use CDH 5.1.0 (5.0.3 recently) with Hive 0.12. I created ORC table with Snappy compression consisted with some integer and string columns. I imported few ~40GB gz files data into HDFS, then as ...
    Wojciech IndykWojciech Indyk
    Aug 11, 2014 at 6:37 am
    Aug 11, 2014 at 7:02 am
  • Hi All, I am trying to add UDF jar from the JDBC Java Client program but somehow getting some errors. I am using HiveServer2 and here is my conf/hive-site.xml <configuration <property <name ...
    Nirmal KumarNirmal Kumar
    Aug 6, 2014 at 8:26 am
    Aug 6, 2014 at 9:04 am
  • I am using cdh5 distribution and It doesn't look like this jira https://issues.apache.org/jira/browse/HIVE-5891 is backported into cdh 5.1.0. Is there a workaround to modify the query that is subject ...
    Chen SongChen Song
    Aug 4, 2014 at 3:00 pm
    Nov 18, 2014 at 6:49 pm
  • Hello, I am switching from Hive 0.9 to Hive 0.12 and decided to start using Hive metadata server mode. As it turns out, Hive1 JDBC driver connected as "jdbc:hive://" only works via direct access to ...
    Alexander KolbasovAlexander Kolbasov
    Aug 12, 2014 at 6:35 am
    Sep 25, 2014 at 8:11 am
  • Hi All, What is the best way to add custom UDF jar in HiveServer2. Currently I am adding it through Java JDBC code : Statement stmt = null; ResultSet res = null; Connection con = ...
    Nirmal KumarNirmal Kumar
    Aug 28, 2014 at 3:20 am
    Sep 1, 2014 at 4:58 am
  • Hi, I have a created a table with fields defined as varchar(length). Is it correct to insert data in to the table casting the fields as VARCHAR(length). I am getting this error. Error occurred ...
    Upd rUpd r
    Aug 26, 2014 at 8:20 pm
    Aug 26, 2014 at 10:17 pm
  • Hi All, I am using hivexmlserde-1.0.5.1.jar to load xml data into hive table. Following is the table DDL create external table h_xml (member_id string,personal_identity map<string,string ...
    Rahul ChanneRahul Channe
    Aug 25, 2014 at 5:24 pm
    Aug 25, 2014 at 10:51 pm
  • Hi, I am passing substitution variable using hiveconf in Hive.. But i couldnt execute simple queries when i am trying to pass more than one parameter. It throws NoViableAltException - ...
    karthik Srivasthavakarthik Srivasthava
    Aug 22, 2014 at 3:55 pm
    Aug 22, 2014 at 6:16 pm
  • Hi all, I have an event table with (user_id, timestamp, event) and I'm trying to write a query to get the first 10 events for each user. My query goes like this : SELECT user_id, event FROM ( SELECT ...
    Furcy PinFurcy Pin
    Aug 20, 2014 at 12:35 pm
    Aug 20, 2014 at 5:47 pm
  • Hi all, I have a Hive table which relies on a JSON SerDe to read the underlying files. When I ran the create script I specified the SerDe and it all went fine and the data was visible in the views ...
    Charles RobertsonCharles Robertson
    Aug 13, 2014 at 12:06 pm
    Aug 17, 2014 at 6:15 pm
  • Hi- I'm using Hive 0.13.1 on Tez and running into an odd null pointer error. If I run a query of the form SELECT foo, bar FROM a UNION ALL SELECT foo, bar FROM b; where either a or b is an empty ...
    Dragga, ChristopherDragga, Christopher
    Aug 15, 2014 at 10:44 pm
    Aug 16, 2014 at 8:24 am
  • Hi, I'm working on HIVE-7142<https://issues.apache.org/jira/browse/HIVE-7142 which should document some information on Hive wiki, while I didn't have write access to Hive wiki yet, could someone help ...
    Li, ChengxiangLi, Chengxiang
    Aug 14, 2014 at 9:39 am
    Aug 15, 2014 at 1:33 am
  • Hi all, I encounter error when I was trying to alter a table not in default database. The command I type is alter table db1.table_A drop partition (id=1); Error info is FAILED: ParseException line ...
    Sky88088Sky88088
    Aug 6, 2014 at 8:47 am
    Aug 7, 2014 at 2:40 am
  • Hi, I am trying to connect using my username and password from JDBC/ODBC tools ( sql workbench/squirrel etc..) to hiveserver2 but always the connection is made with the default user who starts ...
    Sai chaitanya tirumerlaSai chaitanya tirumerla
    Aug 6, 2014 at 12:16 am
    Aug 6, 2014 at 5:35 pm
  • Hello, I'm trying to run this hive benchmark: https://github.com/cartershanklin/hive-testbench. While running the tpcds-setup.sh script, I get the following error: java.io.FileNotFoundException: File ...
    Paweł MichnaPaweł Michna
    Aug 6, 2014 at 11:11 am
    Aug 6, 2014 at 11:31 am
  • Hi, I am having a usecase to read files from hdfs and local file system depending on a configuration parameter. I found that apache commons-vfs supports various file systems and the latest developer ...
    Richards PeterRichards Peter
    Aug 1, 2014 at 6:54 am
    Aug 5, 2014 at 8:05 am
  • Uli BethkeUli Bethke
    Aug 1, 2014 at 10:43 am
    Aug 1, 2014 at 10:51 am
  • Alexander Alten-LorenzAlexander Alten-Lorenz
    Aug 29, 2014 at 7:28 am
    Aug 29, 2014 at 7:34 am
  • Hi guys, I was trying to configure the metastore database, following the steps: 1. sudo apt-get install mysql-server 2. sudo service mysql start 3. sudo apt-get install libmysql-java - copied ...
    Grandl RobertGrandl Robert
    Aug 28, 2014 at 10:32 pm
    Aug 29, 2014 at 3:46 am
  • Hi all my hive version is 0.13.1. Execute the following command hive --hiveconf hive.root.logger=DEBUG,console get Exception message: InvalidObjectException(message:Principal www already has the role ...
    Centerqi huCenterqi hu
    Aug 29, 2014 at 3:08 am
    Aug 29, 2014 at 3:38 am
  • Trying to run a query on Tez with the following configurations *set hive.tez.container.size=5120* *set mapreduce.map.child.java.opts=-Xmx5120M* *set hive.tez.java.opts=-Xmx4096M* *set ...
    Suma ShivaprasadSuma Shivaprasad
    Aug 26, 2014 at 2:18 pm
    Aug 26, 2014 at 2:26 pm
  • Hi, I am trying to run some queries against the metastore, but I am not sure how to query the list of Hive columns in the COLUMNS_V2 table for a specific Hive table in the TBLS table. I want to do ...
    Alex NastetskyAlex Nastetsky
    Aug 25, 2014 at 4:15 pm
    Aug 25, 2014 at 4:36 pm
  • We have released a very basic 32-bit VM (VirtualBox Image) for those users who want to get started with Hadoop, without worrying about configuration and dependencies. We have used CDH5.1 for this ...
    Support TeamSupport Team
    Aug 22, 2014 at 6:08 pm
    Aug 23, 2014 at 4:41 am
  • Hi All, Can somebody help me with alter command to change the hive database location in hive 11 I have tried below commands both are failing alter database <database set location '<location '; alter ...
    Hussain JamaliHussain Jamali
    Aug 22, 2014 at 4:00 pm
    Aug 22, 2014 at 9:12 pm
  • Hey guys How do I denormalize the JSON arrays with a select statement ? Thanks Warm Regards sanjay DDL === USE sansub01 ; ADD JAR ./json-serde-1.3-SNAPSHOT-jar-with-dependencies.jar ; DROP TABLE IF ...
    Subramanian, Sanjay (HQP)Subramanian, Sanjay (HQP)
    Aug 21, 2014 at 7:12 pm
    Aug 21, 2014 at 11:15 pm
  • hi everyone: I followed the wiki https://cwiki.apache.org/confluence/display/Hive/WebHCat+InstallWebHCat to run webhcat server, it's started. I use curl :curl ...
    NoakeNoake
    Aug 15, 2014 at 8:35 am
    Aug 16, 2014 at 5:07 pm
  • We are creating an Hive schema for reading massive JSON files. Our JSON schema is rather large, and we have found that the default metastore schema for Hive cannot work for us as-is. To be specific, ...
    David BeveridgeDavid Beveridge
    Aug 12, 2014 at 12:53 am
    Aug 14, 2014 at 10:34 pm
Group Navigation
period‹ prev | Aug 2014 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions88
posts265
users114
websitehive.apache.org

114 users for August 2014

karthik Srivasthava: 12 posts Nitin Pawar: 11 posts CHEBARO Abdallah: 8 posts Lefty Leverenz: 7 posts Bala Krishna Gangisetty: 6 posts Charles Robertson: 5 posts Grandl Robert: 5 posts Hadoop hive: 5 posts Paweł Michna: 5 posts Tor Ivry: 5 posts André Hacker: 4 posts Andrew Mains: 4 posts ilhami Kalkan: 4 posts Jason Dere: 4 posts Nirmal Kumar: 4 posts Peyman Mohajerian: 4 posts Prasanth Jayachandran: 4 posts Rahul Channe: 4 posts Remy Dubois: 4 posts Subramanian, Sanjay (HQP): 4 posts
show more
Archives