FAQ

Search Discussions

79 discussions - 275 posts

  • Hi, Have installed Hive 0.11 in centos.I see the below error when I execute hive.Can you please help me resolving this. [root@centosvm bin]# hive 13/10/04 09:05:35 WARN conf.HiveConf: DEPRECATED ...
    BaahuBaahu
    Oct 4, 2013 at 12:10 pm
    Oct 10, 2013 at 7:40 am
  • Good morning all, I have another issue this morning. This time with Hive. Hive was working before I restarted the server. My metastore is MySQL on the same server. See error below; [root@bigdata5 ...
    Clay McDonaldClay McDonald
    Oct 17, 2013 at 12:54 pm
    Oct 17, 2013 at 8:41 pm
  • I am pleased to announce that Thejas Nair and Brock Noland have been elected to the Hive Project Management Committee. Please join me in congratulating Thejas and Brock! Thanks. Carl
    Carl SteinbachCarl Steinbach
    Oct 24, 2013 at 10:11 pm
    Oct 28, 2013 at 11:59 pm
  • Hi all, I want to track the changes made to the files of a Hive table. I wounder whether there is any API that I can use to find out the following: 1. What files in hdfs constitute a hive table. 2 ...
    Demian rosasDemian rosas
    Oct 7, 2013 at 6:02 pm
    Oct 7, 2013 at 7:22 pm
  • Hi all, I'm doing a very basic join in Hive and getting the error below. The HiveQL join syntax I'm using is: SELECT T1.somecolumn, T2.someothercolumn FROM t1 JOIN t2 ON (t1.idfield=t2.idfield) ...
    Martin, NickMartin, Nick
    Oct 8, 2013 at 12:14 am
    Feb 6, 2014 at 12:08 am
  • Hi, all, When I using Hive 0.12 with MySQL metastore. I set those properties in hive-site.xml. datanucleus.autoCreateSchema = false datanucleus.autoCreateTables= false In beeline, "show tables" is ...
    Zhang XiaoyuZhang Xiaoyu
    Oct 20, 2013 at 12:07 am
    Oct 23, 2013 at 9:41 pm
  • Hi, all, I am writing a piece of code talking to Hive 0.11 Hive Server 2. The JDBC code depends on libthrift 0.9. However one component which depends on libthrift 0.7 and not binary compatible with ...
    Zhang XiaoyuZhang Xiaoyu
    Oct 10, 2013 at 7:10 pm
    Oct 15, 2013 at 1:35 am
  • Hello all, My employer, AIST, has given the thumbs up to open source our machine learning library, named Hivemall. Hivemall is a scalable machine learning library running on Hive/Hadoop, licensed ...
    Makoto YUIMakoto YUI
    Oct 2, 2013 at 8:23 am
    Oct 11, 2013 at 9:28 am
  • Hi All- I have struggled for awhile with a simple and straightforward driver that I can use to connect to Hive Server 2 in a very similar manner as a mysql driver in python. I know there are a few ...
    Brad RudermanBrad Ruderman
    Oct 23, 2013 at 9:43 pm
    Aug 20, 2014 at 5:25 pm
  • Hi, Can I please have write access to the Hive wiki? I'm writing per the instructions here: https://cwiki.apache.org/confluence/display/Hive/AboutThisWiki. Thanks, Eric
    Eric Hanson (SQL SERVER)Eric Hanson (SQL SERVER)
    Oct 18, 2013 at 12:30 am
    Oct 29, 2013 at 6:55 pm
  • Hi, Source under ODBC seems to be incompatible with HS2's changed RPC thrift interface. Are there any plans on getting an updated version out any time sooner ? Thanks,
    Haroon MuhammadHaroon Muhammad
    Oct 21, 2013 at 12:07 pm
    Oct 22, 2013 at 6:50 pm
  • edu.umd.cloud9.collection.wikipedia.DumpWikipediaToPlainText -input /home/wikimedia/input/ enwiki-latest-pages-articles.xml -output /home/wikimedia/output/3 Jones (30 December 1945 – 29 February ...
    Ajeet S RainaAjeet S Raina
    Oct 3, 2013 at 6:28 am
    Oct 8, 2013 at 9:12 am
  • Hi, I am planning for a Hive External Partition Table based on a date. Which one of the below yields a better performance or both have the same performance? 1) Partition based on one folder per day ...
    Raj HadoopRaj Hadoop
    Oct 31, 2013 at 10:35 pm
    Oct 31, 2013 at 10:56 pm
  • Hi, Can anyone share what's the difference between hive_service.thrift and TCLIService.thrift? Thanks,
    Haroon MuhammadHaroon Muhammad
    Oct 21, 2013 at 6:04 pm
    Oct 22, 2013 at 1:43 pm
  • Hi hive users, I am writing a custom SerDe that loads any protocol buffer generated class. For flexibility this class can live in a jar external to the SerDe's jar and then I just use the Hive ...
    Rui MartinsRui Martins
    Oct 14, 2013 at 12:17 pm
    Oct 14, 2013 at 9:07 pm
  • Hi, I am using Hive 8.1.8 in EMR. We have an extremely large table (~50 columns) where the uniqueness key is a combination of 9 different columns. I want to filter out any duplicate rows based on ...
    Philo WangPhilo Wang
    Oct 2, 2013 at 12:38 am
    Oct 2, 2013 at 9:24 am
  • The following query does not work: SELECT T1.ACCOUNT_NUM ,T1.ACCOUNT_MODIFIER_NUM ,T1.DEPOSIT_TYPE_CD ,T1.DEPOSIT_TERM ,CASE WHEN T1.DEPOSIT_TYPE_CD='5021' THEN '92550000' ELSE CASE WHEN ...
    Xiu GuoXiu Guo
    Oct 16, 2013 at 6:23 pm
    Oct 18, 2013 at 12:06 am
  • Hi All We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1. We have the following query: Is there any option in Hive where mappers can be reduced/fixed? For example if there are 8 mapping ...
    Garg, RinkuGarg, Rinku
    Oct 9, 2013 at 12:21 pm
    Oct 10, 2013 at 7:34 am
  • Hello, I am using some legacy binaries as streaming in Hive. These binaries are dependent on libraries which are installed on all the nodes of the cluster under /user/project_name/lib The env ...
    Vivek thakreVivek thakre
    Oct 7, 2013 at 7:30 pm
    Oct 8, 2013 at 6:43 pm
  • Hi there, We're using the rbhive gem (https://github.com/forward3d/rbhive) to connect to the Hiveserver2 Thrift service running on Hive 0.11. I've turned SASL auth off with the following in ...
    Andy SykesAndy Sykes
    Oct 14, 2013 at 4:45 pm
    Oct 23, 2013 at 5:15 pm
  • Hi all By hive query to display, only field that does not show any results may be what causes it? the sql like follow select * from data where year=2013; hive version is 0.10 -- In the Hadoop world, ...
    Kun yanKun yan
    Oct 17, 2013 at 2:48 am
    Oct 17, 2013 at 5:12 am
  • Hi All, Does hive (0.12) support sql statement "create TABLE tmp_table AS select * from user_table limit 500". Currently I'm running 0.10 version, where its not supported. Regards, Adline
    Adline DsilvaAdline Dsilva
    Oct 16, 2013 at 5:49 am
    Oct 16, 2013 at 7:30 am
  • +1 (binding) 3 days is the minimum length of the voting period, not the maximum. Thanks. Carl
    Carl SteinbachCarl Steinbach
    Oct 13, 2013 at 11:37 pm
    Oct 14, 2013 at 8:06 pm
  • Hi, when i run this sql,it fails,can anyone give me a advise -------------------------------------------------------------------------------------------------------------------------------- select ...
    xinyan Yangxinyan Yang
    Oct 11, 2013 at 12:45 pm
    Oct 12, 2013 at 9:05 am
  • Hi, The columns in my Hive table had better include some special characters like / # - However, I found Hive doesn't allow it, and doesn't allow using \ as escape character. all below query fail (1) ...
    Zhang XiaoyuZhang Xiaoyu
    Oct 8, 2013 at 6:27 pm
    Oct 8, 2013 at 11:56 pm
  • Is there a connection pooling mechanism for Hive Metastore Service? I am using embedded Postgres for my testing but in production we are planning to use MySQL.
    S RS R
    Oct 4, 2013 at 6:34 pm
    Oct 7, 2013 at 6:06 pm
  • Hi, I'd like to implement a "latest" partition concept for one of my tables and believe I can simply update the location using alter table X partition (date='latest') set location 'foo'; This assumes ...
    Timothy PotterTimothy Potter
    Oct 2, 2013 at 7:12 pm
    Oct 2, 2013 at 8:27 pm
  • Hi All, Hive Mapreduce jobs failing with the following java.io.IOException: Not a data file error if there are files other than avro in the HDFS. I have created a Hive external table as shown below, ...
    Valluri, SathishValluri, Sathish
    Oct 30, 2013 at 8:47 am
    Nov 8, 2013 at 7:35 pm
  • Hi, all, I set up below property in hive-site.xml. hive.support.concurrency=true hive.zookeeper.quorum=xxxxxxxx But when I HiveServer2 got multiple concurrent query. I see zookeeper exception in ...
    Zhang XiaoyuZhang Xiaoyu
    Oct 23, 2013 at 12:39 am
    Nov 3, 2013 at 1:44 am
  • Hi, I have a question if I could use the cluster by clause in a sub query to improve the performance of a group by query in hive Lets I have a Table A with columns (all strings) col1..col5 and the ...
    KayVajjKayVajj
    Oct 28, 2013 at 8:18 pm
    Nov 1, 2013 at 6:56 am
  • Hi! Sorry to ask such a basic question, but How do I import data from a text file with fixed columns (no delimiter)? I.e, column 1 is characters 1-6, column 2 is characters 7-11, column 3 is ...
    P ReederP Reeder
    Oct 28, 2013 at 7:48 pm
    Oct 28, 2013 at 8:27 pm
  • We have a table called employee.dat with below contents: 1,ryan,d'souza,it,20000 2,michael,fernandes,admin,25000 then in Hive, query: create table myTbl (a INT, b STRING) ROW FORMAT DELIMITED FIELDS ...
    Xiu GuoXiu Guo
    Oct 23, 2013 at 11:54 pm
    Oct 24, 2013 at 9:55 pm
  • Hi All, When running Hive 12 with Hadoop 2.x with ORC, I get the following error while converting a table with text file to ORC format table. Any help will be greatly appreciated 2013-10-22 ...
    Rajesh BalamohanRajesh Balamohan
    Oct 22, 2013 at 1:53 pm
    Oct 22, 2013 at 11:25 pm
  • Hi All, We have installed cludera hadoop-2.0.0-mr1-cdh4.2.0 with hive-0.10.0-cdh4.2.0. Both are working as desired. We can run any query on hive shell. We also installed cloudera impala 1.1 . Show ...
    Garg, RinkuGarg, Rinku
    Oct 22, 2013 at 8:14 am
    Oct 22, 2013 at 9:20 am
  • All, When a query is executed like the below select field1 from table1 where field1 is null; I am getting the results which have empty values or nulls in field1. How does is null work in Hive ...
    Raj HadoopRaj Hadoop
    Oct 16, 2013 at 2:09 pm
    Oct 17, 2013 at 6:04 pm
  • Hi, all, I am simply using ORC file to store the data and get below exception. Any idea what's wrong with it? create table test (f1 int) stored as orc tblproperties ("orc.compress"="NONE"); load data ...
    Zhang XiaoyuZhang Xiaoyu
    Oct 17, 2013 at 6:35 am
    Oct 17, 2013 at 7:01 am
  • I want to find the most frequent value of a column, I noticed histogram_numerc, but I cannot specify the bin boundary. The result is not what I want. take an example as follows, I want something like ...
    RichardRichard
    Oct 16, 2013 at 11:09 am
    Oct 17, 2013 at 1:05 am
  • Hello, I have a data manipulation query. I have my data in the following format: *Date PLZ Count* date1 plz1 count1 date1 plz1 count2 date1 plz1 count3 date1 plz2 count4 date1 plz2 count5 date1 plz3 ...
    Panshul WhisperPanshul Whisper
    Oct 10, 2013 at 11:54 am
    Oct 10, 2013 at 12:43 pm
  • I use CassandraStorage and HCatalog in my Pig analytics jobs and they are using different versions of Thrift. I'm curious if the Pig load / store funcs could use the WebHCat REST interface instead of ...
    Timothy PotterTimothy Potter
    Oct 8, 2013 at 6:03 pm
    Oct 9, 2013 at 12:23 am
  • I'm trying to create a subset of a large table for testing. The following approach works: create table subset_table as select * from large_table limit 1000 ...but it only uses one reducer. I would ...
    Keith WileyKeith Wiley
    Oct 2, 2013 at 6:48 pm
    Oct 3, 2013 at 7:08 pm
  • Hi, I understand in Hive 0.11 the default JDBC server is server2. Is it possible to run the old server1 and new server2 concurrently so it takes different version of client access? If possible, what ...
    Xiu GuoXiu Guo
    Oct 2, 2013 at 12:46 am
    Oct 2, 2013 at 1:13 am
  • Hi Nitin, Can you please help me with HUE issue. I am not able to create table in HUE using HCatalog? Thanks, Shouvanik This message is for the designated recipient only and may contain privileged, ...
    Shouvanik HaldarShouvanik Haldar
    Oct 1, 2013 at 9:54 am
    Oct 1, 2013 at 10:17 am
  • Hi, In my deployment I have an SSL connection only PostGre SQL server. I tried giving the postgres IP with &SSL=true, but Hive is unable to find the certificates. I have no clue where Hive or PG's ...
    Kanwaljit SinghKanwaljit Singh
    Oct 29, 2013 at 8:11 am
    Oct 29, 2013 at 8:31 am
  • Hi All, I have a scenario where I've to read an RCFile, process it and write the output as an RCFile using a MapReduce program. My Hadoop version is *CDH 4.2.1 * * * *Mapper* Map Input <Key,Value = ...
    Krishnan KKrishnan K
    Oct 21, 2013 at 6:40 pm
    Oct 22, 2013 at 2:02 am
  • Hello, I am trying to implement Serde in hive for reading Json files directly into my hive tables. I am using cloudera hue for querying to the hive server. Where can I get the cloudera hive serde ...
    Panshul WhisperPanshul Whisper
    Oct 16, 2013 at 1:43 pm
    Oct 16, 2013 at 3:37 pm
  • Hive variables do not seem to be evaluated by the assigned expression, so they seem to be macros not variables. Let us say I want to have a variable called secondsInADay and for clarity set it thus ...
    Ed SoniatEd Soniat
    Oct 15, 2013 at 9:50 am
    Oct 15, 2013 at 4:08 pm
  • Hi: Currently, our hive_to_hdfs function has two parts. The first part retrieves transactions records in Hive, put into a temporary file in local file system.The second part puts temporary file in ...
    Sonya LingSonya Ling
    Oct 15, 2013 at 12:35 am
    Oct 15, 2013 at 3:07 am
  • Here's some simple Pig that reads from one Hive table and writes to another (same data, same schema): sigs_in = load 'signals' using org.apache.hcatalog.pig.HCatLoader(); sigs = filter sigs_in by ...
    Timothy PotterTimothy Potter
    Oct 10, 2013 at 8:43 pm
    Oct 14, 2013 at 9:49 pm
  • Dear Hivers, I am a user of HIVE ( or HIVE-TEZ banch). I want to let hive use on Hadoop-3.0.0-SNAPSHOT. I have changed hadoop version when I compiled hive. But it still doesn't work with ...
    Tim ChouTim Chou
    Oct 12, 2013 at 11:28 pm
    Oct 14, 2013 at 9:16 pm
  • I have the requirement trying to support in hive, not sure if it is doable. I have the hadoop 1.1.1 with Hive 0.9.0 (Using deby as the meta store) If I partition my data by a dt column, so if my ...
    Java8964 java8964Java8964 java8964
    Oct 11, 2013 at 5:06 pm
    Oct 11, 2013 at 7:31 pm
Group Navigation
period‹ prev | Oct 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions79
posts275
users84
websitehive.apache.org

84 users for October 2013

Nitin Pawar: 23 posts Timothy Potter: 18 posts Zhang Xiaoyu: 10 posts Clay McDonald: 8 posts Edward Capriolo: 8 posts Ajeet S Raina: 7 posts Sanjay Subramanian: 7 posts Sonal Goyal: 7 posts Baahu: 6 posts Garg, Rinku: 6 posts Mikhail Antonov: 6 posts Raj Hadoop: 6 posts Thejas Nair: 6 posts Xiu Guo: 6 posts Brad Ruderman: 5 posts Demian rosas: 5 posts Haroon Muhammad: 5 posts Martin, Nick: 5 posts Stephen Sprague: 5 posts Yin Huai: 5 posts
show more
Archives