FAQ

Hive > user > February 2014

Search Discussions

93 discussions - 301 posts

  • I am pleased to announce that Xuefu Zhang has been elected to the Hive Project Management Committee. Please join me in congratulating Xuefu! Thanks. Carl
    Carl SteinbachCarl Steinbach
    Feb 28, 2014 at 9:21 am
    Feb 28, 2014 at 7:53 pm
  • Dear experts, I want to move my hive tables from one cluster to another cluster. how can i do it? Thanks Soniya.
    soniya Bsoniya B
    Feb 28, 2014 at 2:08 am
    Mar 4, 2014 at 9:05 pm
  • Hi, It might happen that hiveserver2 memory gets exhausted. Similarly there would be many other things to monitor for hiveserver2. Is there any monitoring tool available in the market? I am using ...
    Shouvanik HaldarShouvanik Haldar
    Feb 20, 2014 at 11:47 pm
    Feb 21, 2014 at 5:25 pm
  • Hi, I have a UDTF which works fine except when I do a query like the following : select e.* from mytable LATERAL VIEW myfunc(p1,p2,p3,p4) e as f1,f2,f3,f4 where lang=123and e.f3 < null; The error I ...
    Kumar VKumar V
    Feb 21, 2014 at 3:19 pm
    Feb 27, 2014 at 7:06 pm
  • Hi folks, We are running CDH 4.3.0 Hive (0.10.0+121) with a MySQL metastore. In Hive, we have an external table backed by HDFS which has a 3-level partitioning scheme that currently has 15000+ ...
    Norbert BurgerNorbert Burger
    Feb 22, 2014 at 3:06 am
    Feb 27, 2014 at 2:32 pm
  • Hello All, I have a use case where a table say TABLE_SQL is geting updated like. 1st Update Command update TABLE_SQL a set BALANCE = b.prev from TABLE_SQL_2 b where a.key = b.key and a.code = "1" 2nd ...
    Yogesh dhariYogesh dhari
    Feb 18, 2014 at 12:40 pm
    Feb 20, 2014 at 7:05 am
  • i have two queries 1. select * from tab1 limit 3; this returns the 3 rows quickly withoput launcing any map reduce jobs; 2. INSERT OVERWRITE LOCAL DIRECTORY "/tmp/query1/" select * from tab1 limit ...
    SreenathSreenath
    Feb 14, 2014 at 10:43 am
    Feb 14, 2014 at 11:45 am
  • Hi all, I'm running a query that scans a file stored in ORC format and extracts some columns. My file is about 92 GB, uncompressed. I kept the default stripe size. The MapReduce job generates 363 map ...
    Avrilia FloratouAvrilia Floratou
    Feb 10, 2014 at 8:50 am
    Feb 10, 2014 at 10:54 pm
  • Hi, I am using java reducer reading from a table, and then write to another one: FROM ( FROM ( SELECT column1,... FROM table1 WHERE ( partition 6 and partition < 12 ) ) A MAP A.column1,A.... USING ...
    Chen WangChen Wang
    Feb 3, 2014 at 6:14 am
    Feb 26, 2014 at 3:42 pm
  • Hi , I have created a external table and when I provide the location of the data for this table I get the following error: FAILED: Error in metadata ...
    Rishabh BhardwajRishabh Bhardwaj
    Feb 27, 2014 at 7:26 am
    Mar 5, 2014 at 9:50 am
  • Hi, I am new with Hadoop and Hive, and I am trying to figure out what is = going wrong. In my application I connect successfully to the Hive and I am able to = load data into it. When I try to run a ...
    Jone LuraJone Lura
    Feb 21, 2014 at 9:26 am
    Feb 21, 2014 at 10:09 am
  • I'm working with an HBase database with a column of the form 'cf:q1:q2' where 'cf' is the column family 'q1:q2' is the column qualifier. When trying to map this in Hive I'm using a statement like the ...
    DenDen
    Feb 14, 2014 at 3:47 pm
    Feb 20, 2014 at 2:12 am
  • Hello, Has anyone implemented Kerberos authentication for Apache Hive? Kerberos authentication for Hadoop is documented very well, and I am able to do it. Connecting databases like MongoDb, ...
    Anilkumar KalshettiAnilkumar Kalshetti
    Feb 11, 2014 at 10:33 am
    Feb 17, 2014 at 5:28 pm
  • Hello. I am running Hive 0.12.0 & Hadoop 2.2.0. I attempted to apply the fix described in the patch here: https://issues.apache.org/jira/secure/attachment/12617931/HIVE-5991.1.patch I applied the ...
    Bryan JeffreyBryan Jeffrey
    Feb 12, 2014 at 7:36 pm
    Feb 13, 2014 at 6:40 pm
  • Reading the Wiki (cwiki.apache.org/confluence/display/Hive/GettingStarted), it states "It does not work on Cygwin." Do further details exist or hints to make work on Windows?
    Ian JacksonIan Jackson
    Feb 4, 2014 at 4:55 pm
    Feb 5, 2014 at 10:06 pm
  • The Apache Hive PMC has voted to make Remus Rusanu a committer on the Apache Hive Project. Please join me in congratulating Remus! Thanks. Carl
    Carl SteinbachCarl Steinbach
    Feb 26, 2014 at 4:59 pm
    Feb 26, 2014 at 5:23 pm
  • Hello! all I wish to find a function that returns hive day of the week (Monday, Tuesday .. etc) to enter a parameter (timestamp). Anyone have an idea of how to do it? -- [image: BEEVA] *Eduardo Parra ...
    Eduardo Parra Valdes | BEEVAEduardo Parra Valdes | BEEVA
    Feb 10, 2014 at 4:33 pm
    Feb 11, 2014 at 2:31 pm
  • Hi, How can I just find out the physical location of a partitioned table in Hive. Show partitions <tab name gives me just the partition column info. I want the location of the hdfs directory / files ...
    Raj HadoopRaj Hadoop
    Feb 6, 2014 at 6:24 pm
    Feb 6, 2014 at 8:20 pm
  • Hi, I am planning to use hive for my use case, but I am confused between hive 0.12 and hive 0.11. Hive 0.12 has been there for reasonable amount of time , while hive 0.11 has been marked as stable ...
    Twinkle sachdevaTwinkle sachdeva
    Feb 27, 2014 at 7:12 am
    Feb 27, 2014 at 11:00 am
  • I have a partitioned table on timestamp_dt: OK ddnamesyskg string totalcount int timestamp_dt string hive select * from daily_count_per_kg_domain; OK sys_kg_band 224 20140219 sys_kg_event 3435 ...
    ManishManish
    Feb 25, 2014 at 9:14 pm
    Feb 27, 2014 at 12:11 am
  • I am trying to upgrade from Hive 0.10 to 0.12, but I am stuck trying to debug an error I keep getting. I have a couple of SerDes that I have developed, but when I try to query tables with these ...
    Andreas KochAndreas Koch
    Feb 23, 2014 at 12:06 pm
    Feb 26, 2014 at 7:57 am
  • I am trying to load 1.4M records in a 7 column CSV file into hbase. Question 1: Is this feasible? Question 2: What type of tuning on hbase and or hdfs would be needed? I am using apache hbase 0.94.15 ...
    Kennedy, Sean C.Kennedy, Sean C.
    Feb 14, 2014 at 4:00 pm
    Feb 17, 2014 at 2:37 pm
  • Hi, I have been unsuccessful trying to setup Hive 0.12 with HBase 0.96.1.1. I am able to get both Hive and HBase to work independently of each other, but when I attempt to map a Hive table to an ...
    Josh DranerJosh Draner
    Feb 12, 2014 at 3:06 am
    Feb 16, 2014 at 7:20 pm
  • Hi, I am facing this situation for the below mentioned hql file - the directory) ---------- -- database pp_test_hive_metastore drop database if exists pp_test_hive_metastore cascade; create database ...
    Naga VijayNaga Vijay
    Feb 2, 2014 at 7:11 am
    Feb 3, 2014 at 1:03 am
  • Hi all, (Running Hive 12.0) I have two tables and both are stored as ORC. I attempted to insert via select from tbl1 to tbl2 using 'BETWEEN' in my where clause to narrow down some dates. Something ...
    Martin, NickMartin, Nick
    Feb 26, 2014 at 4:56 pm
    Feb 28, 2014 at 12:38 am
  • Hi, I am trying to read hive table using PIG script but when I run a pig code to read a table in hive its giving me following error 2014-02-12 15:48:36,143 [main] WARN ...
    Chhaya VishwakarmaChhaya Vishwakarma
    Feb 12, 2014 at 10:33 am
    Feb 26, 2014 at 6:04 pm
  • Hi, I have encountered a problem when I try to deploy my application on Jetty. In my Junit test environment everything works fine, whilst deploying the same application in Jetty I receive the ...
    Jone LuraJone Lura
    Feb 21, 2014 at 1:31 pm
    Feb 26, 2014 at 12:02 pm
  • Hi, I am loading data to HDFS files through sqoop and creating a Hive table to point to these files. The mapper files through sqoop example are generated like this below. part-m-00000 part-m-00001 ...
    Raj HadoopRaj Hadoop
    Feb 26, 2014 at 1:45 am
    Feb 26, 2014 at 3:36 am
  • I am trying to create a Hive partition like 'tr_date=2014-01-01' FAILED: ParseException line 1:58 mismatched input '-' expecting ) near '2014' in add partition statement hive_ret_val: 64 Errors while ...
    Raj HadoopRaj Hadoop
    Feb 26, 2014 at 1:19 am
    Feb 26, 2014 at 1:38 am
  • Hi, Is the Hive 0.12 release still not considered "stable"? The stable directory in the apache mirrors show Hive 0.11 as the stable version. I am testing it with Hadoop 2.2.0 and Oozie 4.0.0 which is ...
    Bhaskar DuttaBhaskar Dutta
    Feb 25, 2014 at 2:57 pm
    Feb 25, 2014 at 5:55 pm
  • Hi Hive Users , I have used below 2 variables to override the location of log files. Default location is /tmp * hiveconf hive.log.dir * hiveconf hive.querylog.location= It works fine, but when I have ...
    Arafat, MoizArafat, Moiz
    Feb 21, 2014 at 12:07 pm
    Feb 24, 2014 at 9:50 am
  • Hi, I have tried some variations of queries with aggregation function such as the following query; select max(total) from my_table; and select id, sum(total) from my_table group by id In my junit ...
    Jone LuraJone Lura
    Feb 21, 2014 at 7:36 pm
    Feb 24, 2014 at 7:54 am
  • Hi, HiveServer2 is getting crashed every now and then, within an interval to 2 days or so. Is this related to memory leak or something? Developers are executing very complex queries which they ...
    Shouvanik HaldarShouvanik Haldar
    Feb 18, 2014 at 11:19 pm
    Feb 20, 2014 at 12:24 am
  • Hi, I'd like to contribute update Hive's wiki. Could you give me a permission to write it? As described in HIVE-4232, we need to set "auth=noSasl" option to connect hiveserver2 from beeline. We ...
    Tsuyoshi OZAWATsuyoshi OZAWA
    Feb 18, 2014 at 4:42 am
    Feb 18, 2014 at 4:07 pm
  • Hey all So, what I'm looking to do is get N randomly-sampled distinct values from a column in a table. I'm kind of flummoxed by how to do this without using TABLESAMPLE, which would require me to add ...
    Oliver KeyesOliver Keyes
    Feb 11, 2014 at 9:08 pm
    Feb 14, 2014 at 10:54 am
  • Hello: While running the hive query : hive select "Actor", count (*) from metrics where array_contains(type_tuple, "Actor") and checkAttributes (attribute_tuple, "p1", "Actor") ; I get this error ...
    ManishManish
    Feb 13, 2014 at 5:16 pm
    Feb 13, 2014 at 7:59 pm
  • I'm working on a UDAF that takes in a constant string that defines what the final output of the UDAF will be. In the mode=PARTIAL1 call to the init function all the parameters are available and the ...
    John MeagherJohn Meagher
    Feb 10, 2014 at 9:27 pm
    Feb 12, 2014 at 7:33 pm
  • Hi, My requirement is a typical Datawarehouse and ETL requirement. I need to accomplish 1) Daily Insert transaction records to a Hive table or a HDFS file. This table or file is not a big table ( ...
    Raj HadoopRaj Hadoop
    Feb 10, 2014 at 2:46 am
    Feb 10, 2014 at 1:24 pm
  • I have come across a strange situation in hive and I want to know if there is an explanation. The CASE operation below does not work when the operator is != but does work then the operator is = ...
    Blaine ElliottBlaine Elliott
    Feb 5, 2014 at 6:50 pm
    Feb 9, 2014 at 8:01 am
  • Hey all, So, I'm new to hive (I come to it from MySQL/MariaDB) and I've spent the last couple of days banging my head against the problem of trying to retrieve data from a join of two tables in ...
    Oliver KeyesOliver Keyes
    Feb 7, 2014 at 12:26 am
    Feb 7, 2014 at 1:19 am
  • I am trying to create a Hive sequence file from another table by running the following - Your query has the following error(s): OK FAILED: ParseException line 5:0 cannot recognize input near 'STORED' ...
    Raj HadoopRaj Hadoop
    Feb 5, 2014 at 5:08 pm
    Feb 5, 2014 at 9:15 pm
  • Dear all, I created a compact index for a table with several hundred million records as follows. The table is partitioned by the month. The index on A and B was created successfully, but I can't see ...
    Thilina GunarathneThilina Gunarathne
    Feb 3, 2014 at 4:09 pm
    Feb 4, 2014 at 3:26 pm
  • Our platform has a 40GB raw data file that was compressed lzo (12GB compressed) to reduce network IO between S3. Without indexing the file is unsplittable resulting in 1 map task and poor cluster ...
    KingDaviesKingDavies
    Feb 3, 2014 at 6:20 pm
    Feb 4, 2014 at 1:34 pm
  • I have two clusters, but small dev clusters, and I loaded the same dataset into both of them. The data size on disk is within 2000 Bytes. Both are ORC, one is Hive 11 and one is Hive 12. One is ...
    John OmernikJohn Omernik
    Feb 3, 2014 at 1:26 am
    Feb 4, 2014 at 1:16 am
  • Looks like hive_test is 1) mainly built to test hive only apps 2) specified for hadoop 0.2x Any one running hive_test in different environments? If so and any hints would love to adopt it ... We've ...
    Jay VyasJay Vyas
    Feb 1, 2014 at 1:35 pm
    Feb 1, 2014 at 3:23 pm
  • Hi all GBK encoding data files, but the hive is UTF-8 encoding select * from table display normal I try to modify the following configuration system:file.encoding=UTF-8 system:sun.jnu.encoding=UTF-8 ...
    Kun yanKun yan
    Feb 20, 2014 at 3:22 am
    Mar 4, 2014 at 8:09 am
  • Hi, Hive 12 has added the functionality of parallel order by. I have a few queries regarding the working of it. partition table needs to created which is provided as an input to ...
    Vaibhav JainVaibhav Jain
    Feb 21, 2014 at 4:32 am
    Mar 4, 2014 at 8:07 am
  • Hi, I'm have a flume stream that stores data in a directory which is source for an external table in hive. However flume creates tmp file that cannot be read by hive and query breaks. Is there any ...
    P lvaP lva
    Feb 28, 2014 at 7:09 pm
    Feb 28, 2014 at 7:35 pm
  • Hi all, I am trying to understand why I receive the following exception; java.sql.SQLException: Error while processing statement: FAILED: SemanticException Line 1:23 Invalid path ...
    Jone LuraJone Lura
    Feb 28, 2014 at 9:22 am
    Feb 28, 2014 at 5:12 pm
  • Hi all, we've experienced a bug which seems to be caused by having a query constraint involving partitioned columns. The following query results in "FAILED: NullPointerException null" being returned ...
    Krishna RaoKrishna Rao
    Feb 27, 2014 at 12:45 pm
    Feb 27, 2014 at 6:44 pm
Feb 2014
12
Group Navigation
period‹ prev | Feb 2014 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions93
posts301
users98
websitehive.apache.org

98 users for February 2014

Stephen Sprague: 18 posts Raj Hadoop: 15 posts Prasanth Jayachandran: 13 posts Java8964: 10 posts Navis류승우: 9 posts Nitin Pawar: 9 posts Jone Lura: 8 posts Lefty Leverenz: 8 posts Shouvanik Haldar: 7 posts Bryan Jeffrey: 7 posts Shashwat shriparv: 6 posts Biswajit Nayak: 5 posts Bogala, Chandra Reddy: 5 posts Brad Ruderman: 5 posts Edward Capriolo: 5 posts Jason Dere: 5 posts John Meagher: 5 posts Kumar V: 5 posts Manish: 5 posts Anilkumar Kalshetti: 4 posts
show more
Archives