FAQ

Search Discussions

47 discussions - 129 posts

  • Hi, Can someone help me with insights into Hive with parquet vs Vertica comparison. I need to store large xml data into one these database so please help me with query performance. Is Impala ...
    Shashidhar RaoShashidhar Rao
    Jan 3, 2015 at 7:17 pm
    Jan 4, 2015 at 9:40 am
  • hi All, I wanted to UPDATE multiple rows in a table by joining it with another table for identification of matching records (otherwise in the RDBMS world also commonly known as SET based UPDATE). The ...
    Devopam MittraDevopam Mittra
    Jan 16, 2015 at 2:09 pm
    Jan 19, 2015 at 3:32 am
  • Hi folks, The window clause in Hive 0.13.* does not work for the following example statement - BETWEEN 2 PRECEDING AND 1 PRECEDING - BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING Is there a reported ...
    DU DUDU DU
    Jan 17, 2015 at 7:42 pm
    Jan 19, 2015 at 3:56 pm
  • At default hive table lines terminated by only supports '\n' right now;But if there is a column that contains a '\n',how could i do ? Hive split the column and went wrong,Is there any solutions ? ...
    王鹏飞王鹏飞
    Jan 13, 2015 at 6:15 am
    Jan 14, 2015 at 1:11 am
  • Recently we find a bug with orc ppd, here is the testcase: use test; create table if not exists test_orc_src (a int, b int, c int) stored as orc; create table if not exists test_orc_src2 (a int, b ...
    WzcWzc
    Jan 4, 2015 at 11:04 pm
    Jan 7, 2015 at 5:29 am
  • Hi, I am new to hive and when I am trying to go to hive prompt I am getting below messages/erros . Is this normal. I am using all default templates, I have not changed any properties in default ...
    Krish DonaldKrish Donald
    Jan 5, 2015 at 6:41 am
    Jan 5, 2015 at 6:07 pm
  • Hi, I am using hive 0.13.1 and currently I am blocked by a bug when joining 2 tables. Here is the sample query. INSERT OVERWRITE TABLE test_archive PARTITION(data='2015-01-17', name, type) SELECT ...
    Guodong WangGuodong Wang
    Jan 15, 2015 at 9:55 am
    Jan 16, 2015 at 4:00 am
  • Hi, I have a Parquet format Hive table with a few columns. I have loaded a lot of data to this table already and it seems to work.I have to add a few new columns to this table. If I add new columns, ...
    Kumar VKumar V
    Jan 7, 2015 at 7:55 pm
    Jan 14, 2015 at 9:20 pm
  • Hi, I am new to hive and I have imported data into HDFS using DB2. Now I want to create hive table. I am not sure How to convert RDBMS DDL to Hive DDL ? Can somebody please guide ? Thanks Krish
    Krish DonaldKrish Donald
    Jan 8, 2015 at 8:28 pm
    Jan 9, 2015 at 12:08 am
  • Does anyone know how to issue a clear screen at the "hive " prompt?Is this even possible? I am looking for something similar to "system clear" in MySQL. Thank you, Louis.
    Louis Vincent FrolioLouis Vincent Frolio
    Jan 1, 2015 at 8:18 pm
    Jan 4, 2015 at 1:50 am
  • Hi, I've been facing some issues in using date_add() I have column 'day_key' that is short integer and stores day keys with respect to 1985/01/01. I need to extract actual date from this column ...
    Yashwanth MYashwanth M
    Jan 16, 2015 at 7:43 am
    Jan 16, 2015 at 9:33 am
  • Env: Hive 0.14 , HDP2.2, Centos 6.6 I created a simple table (ref syntax below) DROP TABLE IF EXISTS twitter_user_info; CREATE TABLE twitter_user_info ( userid BIGINT COMMENT 'User Id', username ...
    Devopam MittraDevopam Mittra
    Jan 14, 2015 at 10:56 am
    Jan 15, 2015 at 1:28 pm
  • Hi all, I'm looking to set a variable in Hive and use the resulting value in a subsequent query. Something like: set startdt='select max(dt) from sometable'; select * from someothertable where ...
    Martin, NickMartin, Nick
    Jan 14, 2015 at 12:45 am
    Jan 15, 2015 at 2:21 am
  • Hi, I have a table with float columns. I tried to query based on the condition on a float column (called 'long'), but it failed (nothing returned). hive select * from test_float where long == ...
    Patcharee ThongtraPatcharee Thongtra
    Jan 13, 2015 at 8:57 am
    Jan 13, 2015 at 9:23 am
  • I got a bunch of small Avro files (<5MB) and have a table against those files. I created a new table and did an 'INSERT OVERWRITE' selecting from the existing table but did not find any option to ...
    Buntu DevBuntu Dev
    Jan 10, 2015 at 12:42 am
    Jan 10, 2015 at 1:31 am
  • Hi, I want to write hive query output into HDFS file in CSV Format( comma separated). For LOCAL DIRECTORY: INSERT OVERWRITE LOCAL DIRECTORY '/home/test/result/' ROW FORMAT DELIMITED FIELDS TERMINATED ...
    Vengatesh.babuVengatesh.babu
    Jan 7, 2015 at 6:17 am
    Jan 9, 2015 at 6:37 pm
  • Hi All: In our process, we have created a temporary table which is built from UNION ALL of 3 different queries. The temp table is used in further query in join. We want to get rid of the temp table ...
    PrashantPrashant
    Jan 6, 2015 at 8:56 pm
    Jan 6, 2015 at 9:42 pm
  • Hi guys, I'm experiencing something very odd: I have an ORC table with the "orc.compress"="SNAPPY" property that weighs 4.9 GB and is composed of 253 files.. I then do a CTAS into a new table where I ...
    Daniel HavivDaniel Haviv
    Jan 19, 2015 at 6:12 am
    Jan 19, 2015 at 7:09 am
  • Hi, I am having a weird problem. I created a table in orc format: -------------------------------- Create table -------------------------------- create external table cossin (x int, y int, cos float, ...
    Patcharee ThongtraPatcharee Thongtra
    Jan 14, 2015 at 2:01 pm
    Jan 14, 2015 at 2:33 pm
  • Hi folks, I’m working on the HIVE-9228 (https://issues.apache.org/jira/browse/HIVE-9228) with the following window query throwing ArrayOutOfBoundExcption. select st_fips_cd, zip_cd_5, hh_surr_key ...
    Aihua XuAihua Xu
    Jan 5, 2015 at 2:52 pm
    Jan 13, 2015 at 5:38 pm
  • Hi, I need write access to Apache Hive confluence. My confluence user id is: *anilkalshetti* Regards, Anil
    Anilkumar KalshettiAnilkumar Kalshetti
    Jan 9, 2015 at 6:53 am
    Jan 9, 2015 at 9:23 am
  • Hi, hive experts We are building a script auto-completion framework for Hive to make Hive easier to use. We are also trying to new We have read the hive compiler design ...
    Xiaoyong ZhuXiaoyong Zhu
    Jan 8, 2015 at 7:02 am
    Jan 9, 2015 at 12:45 am
  • Hi, Hive order by not working properly with columns involved in functions. Column without function: SELECT ACCOUNTID from table order by ACCOUNTID; (Above query works fine in both HIVE &amp; MYSQL) ...
    Vengatesh.babuVengatesh.babu
    Jan 7, 2015 at 10:11 am
    Jan 7, 2015 at 10:38 am
  • Hi, I suspect we have a problem with clients opening connections and not closing them. To verify that I'd like to monitor the Hive's number of threads but I can't seem to find a way to do so. Anyone ...
    Daniel HavivDaniel Haviv
    Jan 6, 2015 at 9:04 am
    Jan 6, 2015 at 9:10 am
  • Hi, I have setup the spark 1.2 standalone cluster and trying to run hive on spark by following below link. https://cwiki.apache.org/confluence/display/Hive/Hive+on+Spark%3A+Getting+Started I got the ...
    Somnath PandeyaSomnath Pandeya
    Jan 5, 2015 at 7:09 am
    Jan 5, 2015 at 10:26 pm
  • I use command "!connect jdbc:hive2://10.1.65.10:10000" to connect hiveserver2 and it occurred some problem as following: 15/01/03 12:27:32 [main]: ERROR jdbc.HiveConnection: Error opening session ...
    王鹏飞王鹏飞
    Jan 3, 2015 at 5:04 am
    Jan 4, 2015 at 8:02 am
  • Any body know Hive-HBase Integration process? Thanks Mohan
    Mohan KrishnaMohan Krishna
    Jan 1, 2015 at 8:39 pm
    Jan 1, 2015 at 10:32 pm
  • Hi All, We have observed that "show create table " is not providing the information on serde's. Is it a bug or intention? describe formatted is showing the serde's info properly. Thanks & Regards, B ...
    AnilKumar BAnilKumar B
    Jan 19, 2015 at 6:34 am
    Jan 19, 2015 at 6:34 am
  • Hi Team, Per the documentation for Hive Storage based authorization in Hive, it has 2 uses: 1. Metastore side authorization 2. Client side authorization I have some questions because after enabling ...
    Jim GreenJim Green
    Jan 16, 2015 at 10:40 pm
    Jan 16, 2015 at 10:40 pm
  • Hi Guys, I am running a docker based hadoop cluster, with hive 0.14 and tez 0.6 I've had successfully managed to make my setup work before, I've increased the input data to my jobs and now I get this ...
    Peterm_secondPeterm_second
    Jan 15, 2015 at 3:45 pm
    Jan 15, 2015 at 3:45 pm
  • Hi, I have a hive table with a column which was changed its name. Pig is not able to load data from this column, it is all empty. Any ideas how to fix it? BR, Patcharee
    Patcharee ThongtraPatcharee Thongtra
    Jan 15, 2015 at 8:41 am
    Jan 15, 2015 at 8:41 am
  • Hi, I have written an application that is contacting with my hive server2. I just want to check how may queries has been submitted on my hive and full details about the query. But when i have grep ...
    Vikas ParasharVikas Parashar
    Jan 15, 2015 at 8:36 am
    Jan 15, 2015 at 8:36 am
  • *Hive 13 I'm storing a sales amount column as a double in an ORC table and when I do: select sum(x) from sometable I get a value like 4.79165141174808E9 A visual inspection of the column values ...
    Martin, NickMartin, Nick
    Jan 15, 2015 at 2:46 am
    Jan 15, 2015 at 2:46 am
  • Just a heads up. For anyone that has been using jdbc:hive I noticed a recent hive... jdbc:hive2://myhost:port SQL exception "Invalid URL" It might be better if the exception said " Invalid URL. Url ...
    Edward CaprioloEdward Capriolo
    Jan 14, 2015 at 10:57 pm
    Jan 14, 2015 at 10:57 pm
  • I have a table that I would like to define to be bucketed, but I also need to write to new partitions using HCatOutputFormat (or similar) from an MR job. I’m getting an unsupported operation error ...
    Brian JeltemaBrian Jeltema
    Jan 13, 2015 at 7:23 pm
    Jan 13, 2015 at 7:23 pm
  • Hi experts I don't know if there is a way to get the hive script output and result programmatically as well as remotely? For example, after using WebHCat to submit a query: describe databases; I want ...
    Xiaoyong ZhuXiaoyong Zhu
    Jan 9, 2015 at 7:57 am
    Jan 9, 2015 at 7:57 am
  • Hi Team, I fail to understand what is the use of hive metastore service when hive service can connect to metastore directly using jdbc ? -- Warm Regards, *Bharath Kumar *
    Bharath KumarBharath Kumar
    Jan 9, 2015 at 4:36 am
    Jan 9, 2015 at 4:36 am
  • The link for mark mail in this page (http://hive.apache.org/mailing_lists.html#Users ) is http://markmail.org/search/+list:org.apache.incubator.hive-user which I think is wrong - it returns no ...
    Xiaoyong ZhuXiaoyong Zhu
    Jan 8, 2015 at 9:00 am
    Jan 8, 2015 at 9:00 am
  • Hi When instantiating the org.apache.hadoop.hive.jdbc.HiveConnection object present in the Java HiveDriver library, when trying to call setReadonly(true), a "Method not supported" exception is ...
    Saravana Kumar VithyananthanSaravana Kumar Vithyananthan
    Jan 8, 2015 at 5:15 am
    Jan 8, 2015 at 5:15 am
  • Hi there, I am trying to load data from a hive view in pig using a HCataLoader. I got the following error: Pig Stack Trace --------------- ERROR 2017: Internal error creating job configuration ...
    Yiming YueYiming Yue
    Jan 8, 2015 at 1:52 am
    Jan 8, 2015 at 1:52 am
  • Hello Hive support team, Happy new year to you! Quick question in regards to combining small LZO files in Hive. As some of our HDFS files are indexed (not all, but there is always a few .lzo.index ...
    Nathalie BlaisNathalie Blais
    Jan 7, 2015 at 8:26 pm
    Jan 7, 2015 at 8:26 pm
  • Hello everyone, I'm trying to monitor performance of a tez query that runs every hour. It was easy to pull the query in the MapReduce. However I'm finding it difficult to pull this info from tez ...
    P lvaP lva
    Jan 6, 2015 at 9:20 pm
    Jan 6, 2015 at 9:20 pm
  • Dear All, I have lots of html data to store. I would like to know which data type should I use ? Is BINARY is a good practice ?‍ Thanks & Regards, Jiaxin
    ZJXZJX
    Jan 6, 2015 at 9:15 am
    Jan 6, 2015 at 9:15 am
  • my code‍ HiveConf conf = new HiveConf(); conf.set(HiveConf.ConfVars.METASTOREURIS.toString(), "thrift://10.136.122.199:10000"); HiveMetaStoreClient hmsc = new HiveMetaStoreClient(conf) ...
    SmartzjpSmartzjp
    Jan 6, 2015 at 9:07 am
    Jan 6, 2015 at 9:07 am
  • Hi, I'm interested in using HCatalog as the unified interface for reading/managing my dataset. The dataset are stored in Parquet format. So my question is how good is Parquet supported in HCatalog? ...
    Jianshi HuangJianshi Huang
    Jan 6, 2015 at 6:58 am
    Jan 6, 2015 at 6:58 am
  • I have a strange situation. I have couple of Hive tables. SELECT * FROM <tablename doesn't return data in HUE. Same query returns the data in CLI or ODBC query tool. What could be the issue? ...
    Nayak, NagarajaNayak, Nagaraja
    Jan 6, 2015 at 1:57 am
    Jan 6, 2015 at 1:57 am
  • is there way to set map and reducer number for hive on tez manually? i want hive on tez to use as many resources as possible
    SkaterXuSkaterXu
    Jan 5, 2015 at 11:26 pm
    Jan 5, 2015 at 11:26 pm
Group Navigation
period‹ prev | Jan 2015 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions47
posts129
users57
websitehive.apache.org

57 users for January 2015

Jason Dere: 7 posts Arthur Hk Chan: 6 posts Devopam Mittra: 6 posts Ashutosh Chauhan: 5 posts Patcharee Thongtra: 5 posts Xiaoyong Zhu: 5 posts Daniel Haviv: 4 posts Edward Capriolo: 4 posts Krish Donald: 4 posts Mohan Krishna: 4 posts Sanjay Subramanian: 4 posts Shashidhar Rao: 4 posts 王鹏飞: 4 posts Abhishek kumar: 3 posts DU DU: 3 posts Kumar V: 3 posts Lefty Leverenz: 3 posts Martin, Nick: 3 posts Vengatesh.babu: 3 posts Wzc: 3 posts
show more
Archives