Grokbase Groups Hive user June 2014

Search Discussions

88 discussions - 274 posts

  • I’m experimenting with HCatalog, and would like to be able to access tables and their schema from a Java application (not Hive/Pig/MapReduce). However, the API seems to be hidden, which leads leads ...
    Brian JeltemaBrian Jeltema
    Jun 13, 2014 at 12:33 pm
    Jun 23, 2014 at 1:14 pm
  • hi, I'm very, very new to Hadoop, Hive, etc. and I have to import data into hive tables. Environment: Amazon EMR, S3, etc. The input file is on S3 and I copied it into my HDFS. 1. flat table with one ...
    Christian LinkChristian Link
    Jun 20, 2014 at 3:27 pm
    Jun 24, 2014 at 11:55 am
  • The Apache Hive PMC has voted to make Gopal Vijayaraghavan and Szehon Ho committers on the Apache Hive Project. Please join me in congratulating Gopal and Szehon! Thanks. - Carl
    Carl SteinbachCarl Steinbach
    Jun 23, 2014 at 3:42 am
    Jun 27, 2014 at 6:46 pm
  • I need to represent an unsigned 64-bit value as a Hive DECIMAL. The current precision maximum is 38, which isn’t large enough to represent the high-end of this value. Is there an alternative? Brian
    Brian JeltemaBrian Jeltema
    Jun 26, 2014 at 3:31 pm
    Jun 29, 2014 at 2:04 pm
  • Hi, I have a table named fino31 with the following schema hive describe fino31; OK date timestamp zone int z int u float v float th float qv float ph float # Partition Information # col_name ...
    Patcharee ThongtraPatcharee Thongtra
    Jun 2, 2014 at 8:06 pm
    Jun 4, 2014 at 12:37 am
  • Hi, I'm very, very new to Hadoop, Hive, etc. and I have to import data into hive tables. Environment: Amazon EMR, S3, etc. The input file is on S3 and I copied it into my HDFS: hadoop distcp ...
    Christian LinkChristian Link
    Jun 20, 2014 at 3:20 pm
    Jun 22, 2014 at 4:58 am
  • hi all, how do I write the following query to insert a note with a current system timestamp? I tried the following; INSERT INTO TEST_LOG VALUES (unix_timestamp(),'THIS IS A TEST.'); thanks, Clay
    Clay McDonaldClay McDonald
    Jun 19, 2014 at 1:17 pm
    Jun 20, 2014 at 7:05 am
  • Hi, Please can someone tell me how to change the date format in hive. I need it in the format '25-JUN-2014' -- Regards, riad
    Jun 25, 2014 at 9:21 pm
    Jun 25, 2014 at 10:11 pm
  • Hi, I am trying to merge few rows in to 1 row. I am stuck. Please help me. Example id col1 col2 col3 col4 1 44 NULL NULL NULL 1 NULL 37 NULL NULL 1 NULL NULL 88 NULL 1 NULL NULL NULL 99 to id col1 ...
    Usha hiveUsha hive
    Jun 24, 2014 at 8:23 pm
    Jun 25, 2014 at 5:45 pm
  • Hi All, I have my date format as 08-Mar-2014 how to I change it to 08-03-2014? Can I use regexp_replace. I tried below but not getting the desired output ...
    Krishnan NarayananKrishnan Narayanan
    Jun 13, 2014 at 12:01 am
    Jun 13, 2014 at 12:46 am
  • I tried to create a table that would use a csv serde. There were various problems with it, primarily in that I couldn't figure out how to specify the path to the serde (whether I indicate the serde ...
    Keith WileyKeith Wiley
    Jun 10, 2014 at 8:56 pm
    Jun 12, 2014 at 1:52 pm
  • Hi, I was wondering if there was a way in Hive to trigger it to perform an efficient equality join on large tables? Specifically, I have two or more tables where the joined key is relatively rare in ...
    Mark DesnoyerMark Desnoyer
    Jun 9, 2014 at 4:50 pm
    Jun 10, 2014 at 1:38 pm
  • Hi All, I have a table named tetsing, name age filename A 21 file1 A 21 file2 B 21 file3 C 23 file3 (partitioned on filename) Now,If I run a query like select distinct name,age from testing; It ...
    Rishabh BhardwajRishabh Bhardwaj
    Jun 5, 2014 at 2:52 pm
    Jun 5, 2014 at 5:14 pm
  • Hi All! I created an hbase table and hcatalog table like the following: hive describe formatted client; OK # col_name data_type comment a string from deserializer b string from deserializer c int ...
    Carlotta HicksCarlotta Hicks
    Jun 30, 2014 at 2:07 pm
    Jul 8, 2014 at 1:48 am
  • I'm trying to run the following hive join query and get the following error. Any suggestions? hive select count(B.txn_id) AS CNT FROM txn_hdr_combined AS B JOIN upc_tab le AS C ON B.txn_id = ...
    Clay McDonaldClay McDonald
    Jun 18, 2014 at 2:26 pm
    Jun 18, 2014 at 9:08 pm
  • Hi, I run Hadoop-2.2.0 + Hive-0.13.0 on a cluster. WordCount example succeeds running and it's ok to create table in hive cli. But when i run hive query with mapreduce jobs, then i keep getting ...
    Jun 16, 2014 at 2:29 pm
    Jun 17, 2014 at 3:52 am
  • Hi folks, we're seeing an intermittent issue between our Hive 0.13 metastore and mysql instance. After being idle for about 5 minutes or so, any transactions involving the metastore and mysql causes ...
    Soam AcharyaSoam Acharya
    Jun 10, 2014 at 7:41 pm
    Jun 11, 2014 at 2:43 pm
  • Hi, I am using Hadoop 2.4.0 with Hive 0.13 + included package of HCatalog . Wrote a simple map-reduce job from the example and running the code below .. getting "Exception in thread "main" ...
    Sundaramoorthy, MalliyanathanSundaramoorthy, Malliyanathan
    Jun 3, 2014 at 6:47 pm
    Jun 5, 2014 at 3:05 pm
  • Hi , I have a query whose result I wanted to store in a variable How can I do it ? I tried ./hive -e "use telecom;insert overwrite local directory '/tmp/result' select avg( a from abc;" ./hive ...
    Chhaya VishwakarmaChhaya Vishwakarma
    Jun 2, 2014 at 7:04 am
    Jun 3, 2014 at 11:35 am
  • I'm having trouble understanding the difference between a skewed table and a list bucketed table: Is the only difference that ...
    Steven WillisSteven Willis
    Jun 27, 2014 at 5:26 pm
    Jul 2, 2014 at 8:38 am
  • Hi I have a Customer table with 200 columns I want to create another table from Customer table which should have only 190 columns. How can i skip few columns in hive from base table? Regards, Chhaya ...
    Chhaya VishwakarmaChhaya Vishwakarma
    Jun 30, 2014 at 9:55 am
    Jul 2, 2014 at 4:46 am
  • HI all, I have changed my hive metastore to mysql using the steps described here ...
    Rishabh BhardwajRishabh Bhardwaj
    Jun 26, 2014 at 8:41 am
    Jun 27, 2014 at 1:57 pm
  • Hey guys, I just discovered that this syntax doesn't print the dbproperties any more. I've two hive versions that i'm testing following query on: create database test2 with dbproperties ('key1' = ...
    Sumit KumarSumit Kumar
    Jun 25, 2014 at 10:58 pm
    Jun 26, 2014 at 5:48 pm
  • My HDFS space is so big I dont thiks this isthe cause of the problem. I will test to increase java heap memory in file 2014-06-23 11:06 GMT+02:00 Nagarjuna Vissarapu <<span ...
    Jun 23, 2014 at 9:16 am
    Jun 25, 2014 at 10:49 pm
  • I’m running Hive 0.12 on Hadoop V2 (Ambari installation) and have been trying to use HBase integration. Hive generated Map/Reduce jobs are failing with: Error: java.lang.ClassNotFoundException ...
    Brian JeltemaBrian Jeltema
    Jun 23, 2014 at 4:14 pm
    Jun 25, 2014 at 11:42 am
  • Hello, We are running Hive 0.12 and using the feature when : = 50000000 hive.mapjoin.followby.gby.localtask.max.memory.usage = 0.7 ...
    Dima MachlinDima Machlin
    Jun 23, 2014 at 8:19 am
    Jun 23, 2014 at 9:07 am
  • How does hive variables work?. if I have multiple Hive jobs running simultaneously? Will they end up picking up values from each other? In automation I am constructing an HQL file by prepending it ...
    Bogala, Chandra ReddyBogala, Chandra Reddy
    Jun 20, 2014 at 9:15 am
    Jun 22, 2014 at 9:32 am
  • Hi all, I brought up some old code that creates a UDAF (User-Defined Aggregate Function) in order to find the range of a column of integer values. However, I am now using an updated Hive (version ...
    Botelho, AndrewBotelho, Andrew
    Jun 16, 2014 at 9:48 pm
    Jun 16, 2014 at 10:35 pm
  • Hi, I like to include common settings in one place when I run different hql script via hive cli. My setting is really script specific, with my understanding of hive, hadoop, it is not very ...
    Jinyuan ZhouJinyuan Zhou
    Jun 16, 2014 at 6:53 pm
    Jun 16, 2014 at 7:12 pm
  • Table statistics collection was added in HIVE-33 (numRows, rawDataSize, etc). Is there anything that lets you create your own statistics gathering? For example, given table A with columns x, y, z, I ...
    Alex NastetskyAlex Nastetsky
    Jun 9, 2014 at 1:33 am
    Jun 10, 2014 at 5:25 am
  • Dear All, Request your help to guide how to store and read XML data in HIVE. while querying it should look as if we are having txt format file under HIVE (it is fine if we use view to parse the XML ...
    Ramasubramanian NarayananRamasubramanian Narayanan
    Jun 6, 2014 at 9:24 am
    Jun 6, 2014 at 10:03 am
  • I run hive-0.13.1 on hadoop-2.2.0. When I insert into an orc table, then i get the following ERROR, indicating that Hive is trying to insert duplicate entry to a table which is called ...
    Jun 26, 2014 at 2:49 am
    Oct 20, 2014 at 1:19 pm
  • I am submitting the following with HCatalog: CREATE TABLE usTestHB (fname string, lname string, cname string) STORED BY 'org.apache.hive.hcatalog.hbase.HBaseHCatStorageHandler ' TBLPROPERTIES ( ...
    Carlotta HicksCarlotta Hicks
    Jun 24, 2014 at 7:40 pm
    Jun 25, 2014 at 6:29 pm
  • Hi! I have install a couple of patches against HCatalog 0.12.0 and need to rebuild it. However, I am new to HCatalog and Hadoop. Can someone show me the necessary command to rebuild HCatalog? We have ...
    Carlotta HicksCarlotta Hicks
    Jun 19, 2014 at 7:43 pm
    Jun 23, 2014 at 4:34 pm
  • Hi guys, I have created a database using this link:, which basically creates a database: tpcds_bin_partitioned_orc_20.db and input data using TPC-DS ...
    Grandl RobertGrandl Robert
    Jun 21, 2014 at 11:30 pm
    Jun 22, 2014 at 9:06 am
  • Why does this not work? hive SELECT CURRENT_TIME; MismatchedTokenException(-1!=107) at org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken( at ...
    Clay McDonaldClay McDonald
    Jun 19, 2014 at 1:50 pm
    Jun 20, 2014 at 8:15 am
  • Hi I recently downloaded the HDP 2.1 Sandbox. I'm trying to create a simple java program that connects to the hive server. I'm using maven with the following dependency: <dependency <groupId ...
    Néstor BoscánNéstor Boscán
    Jun 14, 2014 at 3:49 am
    Jun 14, 2014 at 1:56 pm
  • Hi, Request you to help. Fetching unbounded tags from the xml in hive We tried with xpath but unable to get all the unbounded tags. a sample xml file is <Rows <Row <APPLICATION_ID 1</APPLICATION_ID ...
    Harish tangellaHarish tangella
    Jun 11, 2014 at 5:42 am
    Jun 13, 2014 at 11:34 am
  • Hello, I have a table that each record is in one line (line), and I want to extract all patterns those match in each line, the actuel comportement of the udf regexp_extract returns one occurence ...
    Jun 10, 2014 at 10:12 am
    Jun 11, 2014 at 8:44 am
  • hi All, Can you please redirect/connect me with Hive custom UDF development group. My intent is to create / co-develop custom UDFs for text analytics and data mining over Hive directly. -- Devopam ...
    Devopam MittraDevopam Mittra
    Jun 9, 2014 at 9:14 am
    Jun 9, 2014 at 10:29 am
  • Hi, I am using hive 0.13 and I created a table with a column date in timestamp format. When I used pig script to store data into the table I got exception java.lang.TypeNotPresentException: Type ...
    Patcharee ThongtraPatcharee Thongtra
    Jun 2, 2014 at 7:24 pm
    Jun 3, 2014 at 12:48 am
  • Hi all, I have set mysql as my metastore but when I try to create a table the follwoing error comes.. FAILED: Error in metadata: MetaException(message:javax.jdo.JDODataStoreException: Insert of ...
    Rishabh BhardwajRishabh Bhardwaj
    Jun 26, 2014 at 11:07 am
    Jul 2, 2014 at 2:37 pm
  • Hi all, I have a udf namely gwudf.jar I have it on my local dir at /tmp/gwudf.jar ,and also at hdfs at /user/hive/lib/gwudf.jar so when I am adding this jar, The following error comes Adding like ...
    Rishabh BhardwajRishabh Bhardwaj
    Jun 27, 2014 at 1:56 pm
    Jul 2, 2014 at 5:26 am
  • Hi all, Does anyone know what is the expected behavior on a query like this : FROM source INSERT OVERWRITE TABLE dest SELECT * INSERT INTO TABLE dest SELECT * is it the same as FROM source INSERT ...
    Furcy PinFurcy Pin
    Jun 30, 2014 at 7:16 am
    Jul 1, 2014 at 8:04 am
  • Hi, we are using hive 0.10, the CDH version. CDH version is 4.4 we have our table, partitioned with dates. A partition for everyday. We are trying to use ODBC for connecting to hive. Our select ...
    Prem YadavPrem Yadav
    Jun 29, 2014 at 11:48 am
    Jun 30, 2014 at 12:34 am
  • Hi there, Can my user account 'tr.sudarshan' get write access to this wiki ? ref ...
    Sudarshan RangarajanSudarshan Rangarajan
    Jun 28, 2014 at 1:27 am
    Jun 28, 2014 at 2:16 am
  • Hi, can someone add me to hive wiki editors? My userid is : nitinpawar432 -- Nitin Pawar
    Nitin PawarNitin Pawar
    Jun 24, 2014 at 7:58 pm
    Jun 26, 2014 at 7:17 am
  • Hi all, I have created the Hive table ( million of records). I am using Hue Web UI to run the Hive queires I am running the same queries in both Hive UI ( Beeswax) and Cloudera Impala ( Web UI) in ...
    Ravi PrasadRavi Prasad
    Jun 23, 2014 at 9:42 am
    Jun 25, 2014 at 10:41 pm
  • I haven't been able to find an explicit reference, hoping some one can clarify for me: Do storage handler reads/write get executed as parallel resources, i.e., in an INSERT...SELECT... from a storage ...
    Dean ArnoldDean Arnold
    Jun 19, 2014 at 8:01 pm
    Jun 25, 2014 at 2:57 am
  • subscribe‍
    Jun 22, 2014 at 6:32 am
    Jun 23, 2014 at 12:50 pm
Group Navigation
period‹ prev | Jun 2014 | next ›
Group Overview
groupuser @
categorieshive, hadoop

103 users for June 2014

Brian Jeltema: 14 posts Nitin Pawar: 13 posts Christian Link: 10 posts Matouk IFTISSEN: 10 posts Clay McDonald: 9 posts Andre Araujo: 8 posts Dmitry Vasilenko: 8 posts Edward Capriolo: 6 posts Rishabh Bhardwaj: 6 posts Ashish Garg: 5 posts Carlotta Hicks: 5 posts Chhaya Vishwakarma: 5 posts Douglas Moore: 5 posts Lefty Leverenz: 5 posts Nishant Kelkar: 5 posts 张伟: 5 posts Keith Wiley: 4 posts Mohammad Tariq: 4 posts Navis류승우: 4 posts Patcharee Thongtra: 4 posts
show more