Grokbase Groups Hive user June 2013
FAQ

Search Discussions

90 discussions - 407 posts

  • Hi, I am able to parse the input JSON file and load it into hive. I do not see any errors with create table, so I am assuming that. But when I try to read the data, I get null hive select * from ...
    Sunita ArvindSunita Arvind
    Jun 18, 2013 at 6:24 pm
    Jun 21, 2013 at 8:42 am
  • i have created table after enabling dynamic partition. i partitioned it on date but it is not splitting data datewise. Below is the query of table created and data insert CREATE TABLE ...
    Hamza AsadHamza Asad
    Jun 12, 2013 at 1:48 pm
    Jun 16, 2013 at 1:08 pm
  • Hi, Using hive 0.10.0 over hadoop 1.0.4 I have a (non-partitioned) table with loads of columns. I would like to create a partitioned table with the same set of columns. So the approach that I have ...
    Peter MarronPeter Marron
    Jun 10, 2013 at 1:32 pm
    Jun 13, 2013 at 3:45 am
  • Hello list, I have a hive(0.9.0) setup on my Ubuntu box running hadoop-1.0.4. Everything was going smooth till now. But today when I issued *show tables*I got some strange error on the CLI. Here is ...
    Mohammad TariqMohammad Tariq
    Jun 20, 2013 at 12:54 am
    Jul 1, 2013 at 2:44 am
  • I want to export my table in mysql and for that i'm using sqoop export command but in HDFS i've data apparantly without any field seperator But it does contain some field separator. data is saved in ...
    Hamza AsadHamza Asad
    Jun 18, 2013 at 11:02 am
    Jun 19, 2013 at 11:23 am
  • Dear all, How can i remove data of specific dates from HDFS using hive query language? -- *Muhammad Hamza Asad*
    Hamza AsadHamza Asad
    Jun 3, 2013 at 5:51 am
    Jun 4, 2013 at 3:33 pm
  • Hello Everyone, I'm running into the following Hive external table issue. hive CREATE EXTERNAL TABLE access( ([^ \"]*|\"[^\"]*\") (-|[0-9]*) (-|[0-9]*)(?: ([^ \"]*|\"[^\"]*\") ([^ ...
    Sanjeev sagarSanjeev sagar
    Jun 20, 2013 at 5:22 pm
    Jun 20, 2013 at 7:19 pm
  • Hi, Which of the two query options is better? SELECT a.item_id, a.create_dt FROM a JOIN b ON (a.item_id = b.item_id) WHERE a.item_id = 'I001' AND a.category_name = 'C001'; - or - SELECT a.item_id, ...
    Naga VijayNaga Vijay
    Jun 13, 2013 at 4:17 am
    Jun 16, 2013 at 2:54 am
  • We have a few dozen files that need to be made available to all mappers/reducers in the cluster while running hive transformation steps . It seems the "add archive" does not make the entries ...
    Stephen BoeschStephen Boesch
    Jun 20, 2013 at 12:33 pm
    Jun 20, 2013 at 5:23 pm
  • Hi Folks, I am new to hive and need information, tutorials etc that you can point to. I have installed hive to work with MySQL. I can run queries. Now I would like to understand how the map and ...
    BharatiBharati
    Jun 19, 2013 at 10:54 pm
    Jul 17, 2013 at 7:16 pm
  • Hi, Running Hive 0.11.0 over Hadoop 1.0.4. I would like to be able to "wrap" a Hive table. So, if I have table "X" which uses SerDe "s" and InputFormat "i" then I would like to be able to create a ...
    Peter MarronPeter Marron
    Jun 25, 2013 at 2:31 pm
    Jun 28, 2013 at 8:52 am
  • Hi, is it possible to kill a running query (including all the hadoop jobs behind)? I think it's not, because the Hive JDBC Driver doesn't implement .close() and .cancel() on the (prepared) ...
    Christian SchneiderChristian Schneider
    Jun 25, 2013 at 4:51 pm
    Jun 26, 2013 at 2:19 am
  • Hello Ivry bady, I want to know if is there a way to export headers line in select query to store the result in file from local or HDFS directory? like this query results : set ...
    Matouk IFTISSENMatouk IFTISSEN
    Jun 6, 2013 at 3:42 pm
    Jun 7, 2013 at 8:42 am
  • Hi Experts, I'm trying with the below SQL query in Hive, which does not support column alias access in subsequent columns as shown below in the query. Is there any other way to rewrite the same ...
    Dyuti aDyuti a
    Jun 28, 2013 at 4:58 pm
    Jul 2, 2013 at 1:38 pm
  • I have the following table: f1 f2 f3 f4 f5 a1 a2 P x1 x2 a1 a2 N x3 x4 a1 a3 N x5 x6 a4 a6 P x7 x8 i want to convert to below: f1 f2 pf4 pf5 nf4 nf5 a1 a2 x1 x2 x3 x4 a1 a3 0 0 x5 x6 a4 a6 x7 x8 0 0 ...
    Zuohua zhangZuohua zhang
    Jun 22, 2013 at 10:37 pm
    Jun 23, 2013 at 9:41 pm
  • Hi All, I have 2 questions about complex data types in nested composition. 1 I did not find a way to provide delimiter information in DDL if one or more column has nested array/struct. In this case, ...
    NehaNeha
    Jun 20, 2013 at 8:43 am
    Jun 21, 2013 at 6:24 pm
  • Hi All, Does anyone know the performance impact the dynamic partitions should be expected to have? I have a table that is partitioned by a string in the form 'YYYY-MM'. When I insert in to this table ...
    Shaun ClowesShaun Clowes
    Jun 6, 2013 at 8:25 am
    Jun 18, 2013 at 1:35 am
  • Hi, I have a HBASE table with 2000 + columns. I have to create a HIVE metadata. But am facing issue while creating the HIVE table FAILED: Error in metadata ...
    Shouvanik HaldarShouvanik Haldar
    Jun 6, 2013 at 8:38 am
    Jun 10, 2013 at 8:07 am
  • Hi, everyone: I have set up a hadoop cluster on THREE windows7 machines with Cygwin, and made several test, which were all passed, with hadoop-test-1.1.2.jar and hadoop-examples-1.1.2.jar. Then I ...
    Li jianweiLi jianwei
    Jun 7, 2013 at 1:21 am
    Jun 7, 2013 at 8:35 am
  • Please forgive the cross post, but I could really use some help. I have Hive setup using a remote metastore, backed by H2, and am able to create tables, load data, and query them without issue ...
    Jamal BJamal B
    Jun 3, 2013 at 7:50 pm
    Jun 4, 2013 at 2:39 am
  • Hi, I tried to execute a query in hive but i got the below exception. I dont know the reason. Please help me to resolve the issue. java.net.ConnectException: Call to 192.168.99.33/192.168.99.33:50000 ...
    Manickam PManickam P
    Jun 27, 2013 at 4:25 pm
    Jun 27, 2013 at 8:02 pm
  • Hi, is JDBC the only way to connect to HiveServer 2? I can't find any documentation how to do it with java? There is a Thrift port open, but how to use that? Best Regards, Christian.
    Christian SchneiderChristian Schneider
    Jun 26, 2013 at 1:22 pm
    Jun 27, 2013 at 3:46 pm
  • Hi, I have a performance issue when I query HBase from Hive. My idea is to build the scenario below: 1. Collect data in hbase for aggregation purpose 2. Create an external table that map Hive to ...
    Mario CasolaMario Casola
    Jun 14, 2013 at 3:54 pm
    Jun 18, 2013 at 6:55 am
  • This seems to work just fine in other SQLs, but doesn't seem work in hive. I need to have several wild card characters in my 'like' clause as follows. In other SQLs, I want: .... where page_url_query ...
    Sunderlin, MarkSunderlin, Mark
    Jun 12, 2013 at 1:28 pm
    Jun 14, 2013 at 2:38 am
  • Hello, ant maven-build -Dmvn.publish.repo=local fails to build hcatalog with following error : /home/amareshwaris/hive/build. xml:121: The following error occurred while executing this line ...
    Amareshwari sriramdasuAmareshwari sriramdasu
    Jun 12, 2013 at 11:18 am
    Jun 13, 2013 at 7:46 am
  • Hi, I have hive 0.10 + (CDH 4.2.1 patches) installed on my cluster. I have a table facts520_normal_text stored as a textfile. I'm trying to create a compressed table from this table using GZip ...
    Sachin SudarshanaSachin Sudarshana
    Jun 5, 2013 at 10:18 am
    Jun 6, 2013 at 6:40 pm
  • Hi, I am unable to create a partitioned table. The error I get is: FAILED: ParseException line 37:16 mismatched input '"jobs.values.postingDate.year"' expecting Identifier near '(' in column ...
    Sunita ArvindSunita Arvind
    Jun 26, 2013 at 10:48 pm
    Jul 1, 2013 at 8:44 pm
  • Hi all, Here is the scenario, suppose I have 2 tables A and B, I would like to perform a simple join on them, We can do it like this: INSERT OVERWRITE TABLE C SELECT .... FROM A JOIN B on A.id=B.id ...
    Felix.徐Felix.徐
    Jun 28, 2013 at 3:41 pm
    Jul 1, 2013 at 2:13 am
  • Chris KudelkaChris Kudelka
    Jun 10, 2013 at 3:54 pm
    Jun 21, 2013 at 4:54 pm
  • My hadoop crashes suddenly and not coming out from safe mode. i take back up of my data, format it, and make my hadoop cluster to come out from safe mode but now i have no table in hive-warehouse ...
    Hamza AsadHamza Asad
    Jun 12, 2013 at 8:07 am
    Jun 12, 2013 at 8:39 am
  • Hi, I have been testing the usefulness of compression in Hive. I have a general question, I would like to know if there are any particular cases where compression in hive can actually prove useful ...
    Sachin SudarshanaSachin Sudarshana
    Jun 10, 2013 at 6:04 am
    Jun 11, 2013 at 11:07 pm
  • Hi, I have a table stored as SEQUENCEFILE in hive-0.10,* facts520_normal_seq* Now, i wish to create another table stored as a SEQUENCEFILE itself, but compressed using the Gzip codec. So, i set the ...
    Sachin SudarshanaSachin Sudarshana
    Jun 10, 2013 at 7:48 am
    Jun 10, 2013 at 6:45 pm
  • Hi, currently we are using HiveSever1 with the native HiveClient interface. Our application design looks horrible because (for whatever reason) it spawns a dedicated HiveServer for every query. We ...
    Christian SchneiderChristian Schneider
    Jun 26, 2013 at 12:46 pm
    Jul 4, 2013 at 12:12 am
  • Hi, I feel sure that someone has asked for this before, but here goes... In the case where I have the query SELECT COUNT(*) FROM table; There are many cases where I can determine the count ...
    Peter MarronPeter Marron
    Jun 28, 2013 at 2:55 pm
    Jul 3, 2013 at 1:57 am
  • Hi, I have to import 400 million rows from a MySQL table(having a composite primary key) into a PARTITIONED Hive table Hive via Sqoop. The table has data for two years with a column departure date ...
    Omkar JoshiOmkar Joshi
    Jun 27, 2013 at 4:15 am
    Jun 27, 2013 at 6:52 am
  • Hi, I am moving data from HBase table to a Hive table. I have external Hive table that maps to a HBase table. I perform select query on that external Hive table and insert data to another Hive ...
    Ashish NigamAshish Nigam
    Jun 25, 2013 at 6:03 pm
    Jun 26, 2013 at 11:32 am
  • Hi, I'm using hive 0.10.0 over hadoop 1.0.4. I have created a couple of test tables and found that various join queries that refer to virtual columns fail. For example the query: SELECT * FROM a JOIN ...
    Peter MarronPeter Marron
    Jun 10, 2013 at 8:58 am
    Jun 26, 2013 at 7:11 am
  • I'm using Hadoop 0.20.2 with Hive 0.11. I have succesfully inserted into hive/hdfs some csv-files in seperate tables. selects and joins work flawlessly. When trying to analyse some data, i needed to ...
    Fab wolFab wol
    Jun 21, 2013 at 2:32 pm
    Jun 21, 2013 at 6:19 pm
  • Hi all, I plan to use hive local in order to speed-up unit testing on (very) small data sets. (Data is still on hdfs). I switch the local mode by setting the following variables : SET ...
    Guillaume AllainGuillaume Allain
    Jun 18, 2013 at 11:00 am
    Jun 18, 2013 at 4:15 pm
  • Hi Guys, Executing hive query with filter on virtual column INPUT_*FILE*_NAME result in following exception. hive select count(*) from netflow where INPUT__FILE__NAME='vzb.1351794600.0'; FAILED ...
    Jitendra Kumar SinghJitendra Kumar Singh
    Jun 14, 2013 at 11:28 am
    Jun 17, 2013 at 7:02 am
  • Hi Y'all, I can connect to hive just fine. I can select rows just fine, but anything that appears to require map/reduce crashes consistently. Anyone know of a fix or workaround for this? I'm using ...
    Beau RothrockBeau Rothrock
    Jun 13, 2013 at 5:56 pm
    Jun 14, 2013 at 1:00 am
  • Hello list, I am trying to access data stored in my Hive table through the Java API but looks like I am not using it in the correct manner. Would really appreciate some help. Here is the small piece ...
    Mohammad TariqMohammad Tariq
    Jun 5, 2013 at 6:01 am
    Jun 7, 2013 at 6:28 pm
  • Hi Hive Team, I have Teradata Query as below and my intention is to convert in to Hive Query(HQL). Tried but it's vain. SELECT Col_1, Col_2, Col_3, MIN(Col_3) OVER(Partition by Col_1 ORDER BY Col_3, ...
    Kumar ChinnakaliKumar Chinnakali
    Jun 28, 2013 at 12:53 pm
    Jun 28, 2013 at 4:45 pm
  • Hi, Hopefully a simple question. Given that I have a table name (as a String) is there an API call that I can use to obtain the location of the table? Assume that my code is executing in a custom ...
    Peter MarronPeter Marron
    Jun 27, 2013 at 8:50 am
    Jun 27, 2013 at 10:03 am
  • Hi All, I'm trying to run Hadoop and Hive in a pseudo-distributed mode on my local machine. I've already got hadoop running but when I try to run Hive, it gives me the following error `Exception in ...
    Kannu MehtaKannu Mehta
    Jun 23, 2013 at 11:55 pm
    Jun 24, 2013 at 2:54 am
  • Hi, While working on some complex queries with multiple level of subqueries, I'm wonder if it is possible in Hive to refactor these subqueries into different files and instruct the enclosing query to ...
    Sha LiuSha Liu
    Jun 20, 2013 at 7:59 pm
    Jun 20, 2013 at 8:55 pm
  • Hello I meet I real problem when I lanch a powershell script that execute un other Hive sript below (that cut file from local to HDFS (hortonwork on azure) : Hive script in file “mon_scipt_hive’’ dfs ...
    Matouk IFTISSENMatouk IFTISSEN
    Jun 17, 2013 at 1:07 pm
    Jun 17, 2013 at 2:09 pm
  • Hi, all : How to convert Array to String in Hive0.7? concat_ws(string SEP, array<string ) Like concat_ws() above, but taking an array of strings. (as of Hive 0.9.0) this function was not ...
    LxwLxw
    Jun 14, 2013 at 9:51 am
    Jun 14, 2013 at 4:07 pm
  • Hi All For this UDF, does it consider the week to be from Monday to Monday or first hour of Sunday to the last minute of Saturday for example? Robert -- * Robert Li | Integration and Support Engineer ...
    Robert LiRobert Li
    Jun 13, 2013 at 9:44 pm
    Jun 14, 2013 at 1:48 am
  • Hello list, I have a file stored in my HDFS which contains some urls. File looks like this : abc.in xyz.net http://tariq.com http://tariq.in/sompath And i'm trying to get the hostnames from these ...
    Mohammad TariqMohammad Tariq
    Jun 10, 2013 at 10:00 pm
    Jun 10, 2013 at 10:18 pm
Group Navigation
period‹ prev | Jun 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions90
posts407
users104
websitehive.apache.org

104 users for June 2013

Nitin Pawar: 45 posts Stephen Sprague: 38 posts Hamza Asad: 28 posts Mohammad Tariq: 17 posts Sanjay Subramanian: 17 posts Sunita Arvind: 15 posts Peter Marron: 13 posts Matouk IFTISSEN: 9 posts Christian Schneider: 8 posts Navis류승우: 8 posts Michael Malak: 7 posts Richa Sharma: 7 posts Stephen Boesch: 7 posts Edward Capriolo: 6 posts Lefty Leverenz: 6 posts Ramki Palle: 6 posts Sachin Sudarshana: 6 posts Dean Wampler: 5 posts Shaun Clowes: 5 posts Shouvanik Haldar: 4 posts
show more
Archives