FAQ

Search Discussions

62 discussions - 230 posts

  • Hello. Running the following version of Hadoop: hadoop-2.2.0 Running the following version of Hive: hive-0.12.0 I have a simple test system setup with (2) datanodes/node manager and (1) ...
    Bryan JeffreyBryan Jeffrey
    Dec 17, 2013 at 12:30 am
    Jan 10, 2014 at 3:59 pm
  • I think we should make several changes to the Apache Hive Project Bylaws. The proposed changes are available for review here: https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=38568856 ...
    Carl SteinbachCarl Steinbach
    Dec 27, 2013 at 3:09 am
    Dec 29, 2013 at 8:07 pm
  • Hi All, I have migrated from Apache Hadoop 1.2.0 to Apache Hadoop 2.1.0-beta and now I want to migrate the Hive version(0.10.0 +) as well from an older version(0.7/0/8/0.9). This is since the support ...
    Nirmal KumarNirmal Kumar
    Dec 17, 2013 at 8:44 am
    Jan 16, 2014 at 1:34 pm
  • Hi Hive: I'm attempting to create a robust eclipse based dev environment for testing my hive jobs in localmode however I run into classnotfound errors depending on which maven dependencies I use ...
    Jay VyasJay Vyas
    Dec 28, 2013 at 3:28 am
    Dec 30, 2013 at 1:33 am
  • Hi All, I was trying to drop a database name "default" but every time it fails with the below error message. While other commands works fine like " show database" hive DROP DATABASE IF EXISTS ...
    Biswajit NayakBiswajit Nayak
    Dec 4, 2013 at 12:41 pm
    Dec 5, 2013 at 3:55 am
  • Hi, I have declared several external tables pointing to the same location. The things that tells these tables apart (apart from their names) is that they have unique properties. These properties help ...
    Petter von Dolwitz (Hem)Petter von Dolwitz (Hem)
    Dec 12, 2013 at 12:31 pm
    Jan 20, 2014 at 9:18 am
  • Hi, I am trying to kick off a mapreduce job via WebHCat. The following is the hadoop jar command. hadoop jar /home/hadoop/camus-non-avro-consumer-1.0-SNAPSHOT-jar-with-dependencies.jar ...
    Jonathan HodgesJonathan Hodges
    Dec 30, 2013 at 7:13 pm
    Dec 30, 2013 at 11:21 pm
  • I am pleased to announce that Gunther Hagleitner has been elected to the Hive Project Management Committee. Please join me in congratulating Gunther! Thanks. Carl
    Carl SteinbachCarl Steinbach
    Dec 27, 2013 at 5:00 am
    Dec 28, 2013 at 5:45 am
  • Hi, I have Hive 0.12 and Hadoop 2.2. Hcatalog that has been packaged with Hive 0.12 is built for Hadoop 1. Is there a distribution of Hcatalog built for Hadoop 2 ? regards, sathwik
    Sathwik B PSathwik B P
    Dec 13, 2013 at 7:27 am
    Dec 13, 2013 at 11:18 am
  • Hi, I use hive 0.11 with a five machine cluster. I am reading the property hive.query.string from a custom RecordReader (used for reading external tables). If I first invoke a query like select * ...
    Petter von Dolwitz (Hem)Petter von Dolwitz (Hem)
    Dec 3, 2013 at 12:46 pm
    Dec 11, 2013 at 8:58 am
  • Hi, I am exploring HIVE options on EMR box from Amazon. Once I create a table from HUE(Hadoop User Experience) console, I expect a table to get created on MYSQL as this is the metastore. But I don't ...
    Shouvanik HaldarShouvanik Haldar
    Dec 26, 2013 at 6:25 am
    Dec 26, 2013 at 11:51 am
  • hi,maillist: i am write a bash script,what i want is run "hive -e 'DDL' " in script, and i want judge if the hive DDL is success or fail,how can i do this ?
    Ch huangCh huang
    Dec 2, 2013 at 7:52 am
    Dec 2, 2013 at 1:13 pm
  • Hello All, I have a hive table in which dates are stored in string format. like 2013-01-01 2013-02-01 2013-03-01 I have a use case where I need this date like 20130101 20130201 20130301 and want to ...
    Yogesh dhariYogesh dhari
    Dec 24, 2013 at 6:54 am
    Dec 24, 2013 at 10:27 am
  • I have a customer whose hiveserver2 settings work fine authenticating against one LDAP server where anonymous requests are allowed, but failing against another LDAP server where binding is ...
    Ron EcheverriRon Echeverri
    Dec 20, 2013 at 10:27 pm
    Dec 20, 2013 at 11:34 pm
  • I have just started to experiment with Hbase in our cluster. I have an secure Hbase cluster setup and would like to create an external Hive table around several of our Hbase tables. This works fine ...
    Justin WorkmanJustin Workman
    Dec 9, 2013 at 4:36 pm
    Dec 15, 2013 at 3:50 pm
  • Hi, I'm running TPCH query 21 on Hive. 0.12 and have enabled hive.optimize.correlation. I could see the effect of the correlation optimizer on query 17 but when running query 21 I don't actually see ...
    Avrilia FloratouAvrilia Floratou
    Dec 11, 2013 at 1:06 am
    Dec 11, 2013 at 7:14 pm
  • hi,maillist: we use hive to store UTF8 chinese character ,but query through hive jdbc ,it become some unreadable characters,it's normal to use hive shell.why? it's a bug in hive jdbc?how can i solve ...
    Ch huangCh huang
    Dec 6, 2013 at 6:34 am
    Dec 9, 2013 at 10:56 pm
  • Hi, I am integrating hive(0.12) with hbase(0.96). Everything is working fine there but get stuck between two quires. When i create table or select * from table then it's working fine . but in case of ...
    Vikas ParasharVikas Parashar
    Dec 26, 2013 at 4:36 pm
    Dec 31, 2013 at 5:41 am
  • Dear All Hive Group Members, I have the following requirement. Input: Ticket#|Date of booking|Price 100|20-Oct-13|54 100|21-Oct-13|56 100|22-Oct-13|54 100|23-Oct-13|55 100|27-Oct-13|60 ...
    Raj HadoopRaj Hadoop
    Dec 28, 2013 at 5:57 pm
    Dec 29, 2013 at 3:55 pm
  • Hello Guys, historically concat_ws() UDF was added in the scope of https://issues.apache.org/jira/browse/HIVE-682 ticket. I have a simple question about its implementation. According to above ...
    Alexey ZotovAlexey Zotov
    Dec 26, 2013 at 11:37 am
    Dec 28, 2013 at 9:00 am
  • Hi all, I'm looking for a way to automatically generate an output table schema based on the input and query. Basically, a given input schema and SELECT statement produce a deterministic result ...
    Sean ColganSean Colgan
    Dec 20, 2013 at 11:01 pm
    Dec 23, 2013 at 6:08 pm
  • Hi, all, Is there a way to typecast arrays in hive? What I want is that for a specific select, where I specify and empty array as the value for one of the columns, for Hive to treat the empty array ...
    Andre AraujoAndre Araujo
    Dec 19, 2013 at 6:18 am
    Dec 19, 2013 at 6:36 am
  • hi guys, I'm pretty much at my wits end on this one. i'm using hive v0.12 against a mysql metastore. the error manifests itself (mostly randomly which is the problem) as this error in the client ...
    Stephen SpragueStephen Sprague
    Dec 18, 2013 at 1:12 am
    Dec 19, 2013 at 12:58 am
  • Hi, Excuse me. May I ask a question about running Hive on Tez? I've installed Hive on Tez, and running a simple query from hiveCli, hive set hive.optimize.tez=true; hive select * from table order by ...
    Zhenxiao LuoZhenxiao Luo
    Dec 13, 2013 at 9:12 pm
    Dec 19, 2013 at 12:39 am
  • Sent from Rocket Mail via Android
    Manish BhogeManish Bhoge
    Dec 10, 2013 at 6:20 am
    Dec 11, 2013 at 7:11 pm
  • if I log into my hive shell, do "show databases;" , I see many DBs: Logging initialized using configuration in file:/etc/hive/conf/hive-log4j.properties hive show databases; OK conf confnew default ...
    YangYang
    Dec 30, 2013 at 7:49 pm
    Dec 30, 2013 at 9:39 pm
  • Hi all, I want to know that, whether Hive supports using a custom MapReduce script to load data into a table with static/hybrid/dynamic partitions? I'm working on a log analysis program, for ...
    ZeekvfuZeekvfu
    Dec 26, 2013 at 8:30 am
    Dec 27, 2013 at 2:23 am
  • Hi, What is the difference between hints STREAMTABLE ,MAPJOIN . Thanks, Baahu
    BaahuBaahu
    Dec 3, 2013 at 9:18 am
    Dec 24, 2013 at 9:15 am
  • Hi, I use the HiveStoragePredicateHandler interface on my storage handler to be able to push down filters to my record reader for early pruning. It seems like the IndexPredicateAnalyzer is a bit ...
    Petter von Dolwitz (Hem)Petter von Dolwitz (Hem)
    Dec 11, 2013 at 9:15 am
    Dec 22, 2013 at 12:03 pm
  • To all, I'm trying to connect Tableau to Hive (0.10.0) running Hiveserver2. The connection works ok, until I go to pull in the data. The resulting M/R job is attempting to connect to port 8021 on one ...
    Joseph D AntoniJoseph D Antoni
    Dec 4, 2013 at 4:27 pm
    Dec 5, 2013 at 5:04 pm
  • Is it possible to specify a Hive auxiliary jar (like a SerDe) that is in HDFS rather than the local fileystem? I am using a CsvSerDe I wrote and when I specify it Hive hive.aux.jars.path with a local ...
    Mpeterson2Mpeterson2
    Dec 2, 2013 at 9:14 pm
    Dec 3, 2013 at 4:16 pm
  • hi, how to find number of elements in an array in Hive table? thanks, Raj
    Raj HadoopRaj Hadoop
    Dec 2, 2013 at 10:05 pm
    Dec 3, 2013 at 4:21 am
  • Hi folks.. Is there an JDBC or other API driven, programmatic way to launch a Hive Job using SerDe's from the contrib library? I've been attempting to run a query using Hive's JDBC driver which uses ...
    Jay VyasJay Vyas
    Dec 30, 2013 at 12:18 pm
    Dec 30, 2013 at 6:56 pm
  • Hi all, I'm using Hive 0.12 and running some experiments with the ORC file. The hdfs block size is 128MB and I was wondering what is the best stripe size to use. The default one (250MB) is larger ...
    Avrilia FloratouAvrilia Floratou
    Dec 30, 2013 at 4:36 am
    Dec 30, 2013 at 4:00 pm
  • Hi all, I have two tables: tbl1: 81m rows tbl2: 4m rows tbl1 is partitioned on one column and tbl2 has none. I'm attempting the following query: SELECT tbl1.col_pk, tbl2.col1, tbl2.col2, ...
    Martin, NickMartin, Nick
    Dec 20, 2013 at 7:35 pm
    Dec 30, 2013 at 6:29 am
  • Hello, I have a use case where I need to find the 1st day of the month of entered date. like if the date is 2013-12-05 i need to get 2013-12-01. how to do it in Hive. (wont preffer to use UDF, like ...
    Yogesh dhariYogesh dhari
    Dec 24, 2013 at 10:19 am
    Dec 24, 2013 at 10:56 am
  • Hi Guys, We have an avro backed production table bucketed by a column and it works fine with the old Hive = 0.7 on chd3u2. Now we have moved to Hive 0.12 on HDP 2.0 and are getting bucketing issues ...
    Sagar MehtaSagar Mehta
    Dec 17, 2013 at 12:01 am
    Dec 18, 2013 at 7:21 pm
  • Excuse me. May I ask a question about Hive on Tez? We just started evaluating Hive on Tez. Would like to know, is Hive on Tez development done yet? Is there any documentation we could reference to ...
    Zhenxiao LuoZhenxiao Luo
    Dec 12, 2013 at 1:38 am
    Dec 14, 2013 at 11:22 pm
  • Hi, I have a large set of text files. I have created a Hive table pointing to each of these text files. I am looking to compress the files to save storage. 1) How should I compress the file to use ...
    Raj HadoopRaj Hadoop
    Dec 9, 2013 at 9:11 pm
    Dec 10, 2013 at 5:43 am
  • Hi All, I had setup the hive in my home directory, but today i moved it to /opt. After that starting it throws error:- *Exception in thread "main" javax.jdo.JDOFatalDataStoreException: Unable to open ...
    Biswajit NayakBiswajit Nayak
    Dec 9, 2013 at 6:48 am
    Dec 9, 2013 at 6:54 am
  • Hi All, We have installed CDH4.2.0 and hive-0.10.0-cdh4.2.0. Both are working as desired. Now we want to replace hive-0.10.0-cdh4.2.0 with apache hive 0.12. Will this combination works? Thanks & ...
    Garg, RinkuGarg, Rinku
    Dec 5, 2013 at 12:17 pm
    Dec 5, 2013 at 2:14 pm
  • This can be an interesting subject, I know orgs that are all over on this questions. I'd be interested in hearing what you use, how it works for you, and what you are wishing you had in your ...
    John OmernikJohn Omernik
    Dec 4, 2013 at 5:32 pm
    Dec 4, 2013 at 6:51 pm
  • Hi, I recently wrote a CSV SerDe for Hive. It works in most scenarios, but I've found one situation where Hive is failing with it. I also tried the queries with the opensource CSV SerDe ...
    Mpeterson2Mpeterson2
    Dec 2, 2013 at 5:14 pm
    Dec 2, 2013 at 8:24 pm
  • Hi, I have inserted around 700 million records or 55 GB worth data from staging table to below ORC table. And then I tried running small queries to get few columns data from ORC table. But ORC query ...
    chandra Reddy Bogalachandra Reddy Bogala
    Dec 31, 2013 at 6:34 am
    Dec 31, 2013 at 6:34 am
  • I tried to create a skewed table using the group lens 100k data set and setting the skew columns to the movie rating, but I only see one file get created. My understanding was that separate files ...
    KireetKireet
    Dec 27, 2013 at 12:15 am
    Dec 27, 2013 at 12:15 am
  • Hello all, I have wrote this query . *" select* *case when as_date rlike '2013-05-01' then as_date else '2013-07-04' end as as_date from table AA ; " * as the value of as_date i.e 2013-05-01 exists ...
    Yogesh dhariYogesh dhari
    Dec 24, 2013 at 12:05 pm
    Dec 24, 2013 at 12:05 pm
  • Hi, Has anyone written a python udf that can take the input as the group by of a subquery and process this set to output something. If yes can you please share a query that uses this udf ? -- ...
    SreenathSreenath
    Dec 24, 2013 at 10:19 am
    Dec 24, 2013 at 10:19 am
  • Hi there! I want to run hive (0.11) in embedded/standalone mode against hadoop 2 for running queries for my unit tests. I started with something similar to [1] and then used the hack in [2] to setup ...
    Sumit KumarSumit Kumar
    Dec 23, 2013 at 7:15 am
    Dec 23, 2013 at 7:15 am
  • Hi All, Any one has any idea how to make hive server to emit metrics for ganglia. i tried adding some properties in env file. it does not works. Thanks Biswajit -- The information contained in this ...
    Biswajit NayakBiswajit Nayak
    Dec 20, 2013 at 7:00 pm
    Dec 20, 2013 at 7:00 pm
  • Dear hive users, I recently upgraded my single node cluster from CDH 4.5 to CDH 5 Beta 1 which updated Hive from 0.10 to 0.11 and HBase from 0.94.6 to 0.95.2. Back in CDH 4.5 I created an external ...
    Huynh, Chi-HaoHuynh, Chi-Hao
    Dec 18, 2013 at 5:07 pm
    Dec 18, 2013 at 5:07 pm
Group Navigation
period‹ prev | Dec 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions62
posts230
users83
websitehive.apache.org

83 users for December 2013

Nitin Pawar: 13 posts Lefty Leverenz: 11 posts Jonathan Hodges: 10 posts Biswajit Nayak: 8 posts Edward Capriolo: 8 posts Bryan Jeffrey: 7 posts Jay Vyas: 7 posts Petter von Dolwitz (Hem): 7 posts Prasanth Jayachandran: 7 posts Mpeterson2: 5 posts Ch huang: 5 posts Eugene Koifman: 5 posts Navis류승우: 5 posts Raj Hadoop: 5 posts Yogesh dhari: 5 posts Shouvanik Haldar: 4 posts Adam Kawa: 4 posts Avrilia Floratou: 4 posts Nirmal Kumar: 4 posts Sathwik B P: 4 posts
show more
Archives