Grokbase Groups Hive user July 2013
FAQ

Search Discussions

114 discussions - 419 posts

  • Hi, I have a problem while using RANK OVER PARTITION function with Hive. Hive is in version 0.11 and, as we can see here : https://cwiki.apache.org/Hive/languagemanual-windowingandanalytics.html, we ...
    Jérôme VerdierJérôme Verdier
    Jul 16, 2013 at 8:45 am
    Jul 19, 2013 at 1:29 pm
  • It seems as though I am required to pass in an argument to RANK(). What is the effect of passing this argument in ? In a RANK function the output for RANK should be the number of rows preceding a row ...
    j.barrett Strausserj.barrett Strausser
    Jul 24, 2013 at 7:00 pm
    Sep 24, 2013 at 9:31 am
  • Hi Hive Gurus, When using the Hive extension of multiple inserts, can we add Where clauses for each Select statement, like the following? FROM ...INSERT OVERWRITE TABLE ... SELECT col1, col2, col3 ...
    Sha LiuSha Liu
    Jul 31, 2013 at 3:26 am
    Aug 12, 2013 at 11:49 pm
  • Ariel LeivaAriel Leiva
    Jul 2, 2013 at 4:38 pm
    Jul 18, 2013 at 8:33 pm
  • Hi all, Would someone with the right permissions grant me write access to the Hive wiki? I'd like to update some information on the Avro Serde. Thanks, Mark
    Mark WagnerMark Wagner
    Jul 30, 2013 at 8:07 pm
    Jul 31, 2013 at 4:39 pm
  • hi ,all: i already install and testing lzo in hadoop and hbase,all success,but when i try it on hive ,it failed ,how can i do let hive can recognize lzo? hive set ...
    Ch huangCh huang
    Jul 22, 2013 at 5:37 am
    Jul 24, 2013 at 12:14 am
  • The Apache Hive PMC has passed a vote to make Brock Noland a new committer on the project. Brock, please submit your ICLA to the Apache Software Foundation as described here ...
    Carl SteinbachCarl Steinbach
    Jul 16, 2013 at 5:30 am
    Jul 16, 2013 at 6:42 pm
  • Hello Hive users, Is there a manner to store the Hive query result (SELECT *.....) in a specfique and alone file (given the file name) like (INSERT OVERWRITE LOCAL DIRECTORY '/directory_path_name/')? ...
    Matouk IFTISSENMatouk IFTISSEN
    Jul 4, 2013 at 9:43 am
    Jul 4, 2013 at 4:19 pm
  • Hi, I need some help to translate a PL/SQL script in HiveQL. Problem : my PL/SQL script is calling two functions. you can see the script below : SELECT in_co_societe as co_societe, 'SEMAINE' as ...
    Jérôme VerdierJérôme Verdier
    Jul 25, 2013 at 7:50 am
    Jul 30, 2013 at 7:21 am
  • Hi everybody, I faced a strange error in hive this morning. The error message is this one : FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask after a quick search ...
    Jérôme VerdierJérôme Verdier
    Jul 8, 2013 at 9:26 am
    Jul 16, 2013 at 8:02 am
  • Hi, i trying to translate some PL/SQL script in HiveQL, and dealing with unusual date format. i added a variable in my hive script : '${hiveconf:in_co_an_mois}' which is a year/month date format, ...
    Jérôme VerdierJérôme Verdier
    Jul 2, 2013 at 9:42 am
    Jul 3, 2013 at 5:38 pm
  • hi all: We are currently testing hive 0.11 against our production environment and run into some problems. Some of them are related to the param "hive.auto.convert.join". We disable this param and ...
    Wzc1989Wzc1989
    Jul 28, 2013 at 12:09 pm
    Aug 1, 2013 at 3:34 pm
  • Hi All: We are running into frequent problem using HCatalog 0.4.1 (HIve Metastore Server 0.9) where we get connection reset or connection timeout errors. The hive metastore server has been allocated ...
    AgateaaaAgateaaa
    Jul 29, 2013 at 5:44 pm
    Jul 31, 2013 at 4:49 pm
  • Hi there, I am trying to introduce some sort of security to prevent different people using the cluster from interfering with each other's jobs. Following the instructions at ...
    Murat OdabasiMurat Odabasi
    Jul 30, 2013 at 6:21 pm
    Jul 30, 2013 at 6:52 pm
  • The Apache Hive PMC has voted to make Gunther Hagleitner a committer on the Apache Hive project. Congratulations Gunther! Carl
    Carl SteinbachCarl Steinbach
    Jul 21, 2013 at 8:01 am
    Jul 23, 2013 at 12:33 am
  • i get error when try create table on hbase use hive, anyone can help? hive CREATE TABLE hive_hbasetable_demo(key int,value string) Failed with exception ...
    Ch huangCh huang
    Jul 8, 2013 at 5:55 am
    Jul 9, 2013 at 9:29 pm
  • Hi all, I am writing my first UDAF. In my terminatePartial() function, I need to store different data having different data types. Below is a list of items that I need to store 1. C1 : list of ...
    Ritesh AgrawalRitesh Agrawal
    Jul 29, 2013 at 10:20 pm
    Jul 30, 2013 at 6:05 am
  • Hi, Please help in providing solution for the below problem... this scenario is applicable in Banking atleast... I have a HIVE table with the below structure... Hive Table: Field1 ... Field 10 For ...
    Ramasubramanian NarayananRamasubramanian Narayanan
    Jul 26, 2013 at 10:52 am
    Jul 30, 2013 at 12:02 am
  • Hi, I need to run hive query like select * from employee where employee_id IN (100,102). I came to know that hive does not support IN clause.Then what is the effective replacement for this? i need to ...
    Manickam PManickam P
    Jul 12, 2013 at 11:13 am
    Jul 12, 2013 at 2:12 pm
  • Hi, I would like to know if it is possible to map a composite key stored as blob in HBase to Hive?? Regards, Vijay Raajaa G S
    G.S.Vijay RaajaaG.S.Vijay Raajaa
    Jul 29, 2013 at 11:23 am
    Aug 2, 2013 at 5:38 am
  • Just finishing up testing with Hive 11 and ORC. Thank you to Owen and all those who have put hard work into this. Just ORC files, when compared to RC files in Hive 9, 10, and 11 saw a huge increase ...
    John OmernikJohn Omernik
    Jul 25, 2013 at 11:46 pm
    Jul 27, 2013 at 1:06 am
  • Hi All, I have a table in Apache Hive and I am interested in a specific field of the table. Table name: Table1 and field name f1. The field f1 is of type MAP<string, string . The table is huge. How ...
    R JR J
    Jul 25, 2013 at 6:09 pm
    Jul 27, 2013 at 12:01 am
  • Hello All, Has anyone been successful at running hive 0.11 with Cloudera CDH 4.3? I've been able to get hive to connect to my metadb (which is in Postgres). Verified by doing a show tables.. I can ...
    Jim ColestockJim Colestock
    Jul 16, 2013 at 1:33 am
    Jul 21, 2013 at 10:06 am
  • My hive was working fine when I was using Hadoop 1.0.4. With Hadoop 1.12 and Hive 0.11. I am getting following error while doing any operation on hive like 'show tables' Mysql is running 2013-07-20 ...
    Rishi YadavRishi Yadav
    Jul 20, 2013 at 3:10 pm
    Jul 20, 2013 at 7:52 pm
  • Please let me knw which approach is better. Either i save my data directly to HDFS and run hive (shark) queries over it OR store my data in HBASE, and then query it.. as i want to ensure efficient ...
    Hamza AsadHamza Asad
    Jul 17, 2013 at 5:41 pm
    Jul 18, 2013 at 7:09 am
  • Hi, Can any one please suggest the best way to do the following in Hive? Load 'todays date stamp' + << ALL FIELDS C1,C2,C3,C4 IN A FILE F1 to a Hive table T1 ( D1,C1,C2,C3,C4) Can the following ...
    Raj HadoopRaj Hadoop
    Jul 5, 2013 at 5:01 pm
    Jul 6, 2013 at 7:52 am
  • Hello list, I would really appreciate if someone could show me the correct way of using regexserde as i'm having some hard time using it. I have verified my regex through ...
    Mohammad TariqMohammad Tariq
    Jul 1, 2013 at 2:39 am
    Jul 2, 2013 at 7:50 am
  • Hi, I am newbie to Hive . While creating external tables, can we use wildcard to specify file location. i.e: STORED AS TEXTFILE LOCATION 's3://root/*/date*/' Is the above specification valid in hive ...
    Pandees waranPandees waran
    Jul 22, 2013 at 11:48 am
    Aug 11, 2013 at 5:45 am
  • Hi, I have written a script which generates JSON files, loads it into a dictionary, adds a few attributes and uploads the modified files to HDFS. After the files are generated, if I perform a select ...
    Sunita ArvindSunita Arvind
    Jul 30, 2013 at 7:07 pm
    Aug 2, 2013 at 8:19 am
  • Hello All, Why does TABLESAMPLE(N rows) produce ouptut with 2*N rows? I have the following script: DROP TABLE IF EXISTS sparse_features_small; CREATE TABLE sparse_features_small ROW FORMAT DELIMITED ...
    j.barrett Strausserj.barrett Strausser
    Jul 30, 2013 at 1:52 am
    Jul 30, 2013 at 2:40 am
  • Hi All- I have 2 tables: CREATE TABLE users ( a bigint, b int ) CREATE TABLE products ( a bigint, c int ) Each table has about 8 billion records (roughly 2k files total mappers). I want to know the ...
    Brad RudermanBrad Ruderman
    Jul 29, 2013 at 5:38 pm
    Jul 29, 2013 at 6:37 pm
  • Hi, Need to create a view in HIVE as per the below query (written in Oracle). Need help to provide the equivalent query in HIVE to create view. *EMP_ADDRESS* Emp_Id Address1 Address2 Address3 ...
    Ramasubramanian NarayananRamasubramanian Narayanan
    Jul 26, 2013 at 8:18 am
    Jul 26, 2013 at 5:35 pm
  • I'm having a table in MySQL viz. nas_comps. select comp_code, count(leg_id) from nas_comps_01012011_31012011 n group by comp_code; comp_code count(leg_id) 'J' 20640 'Y' 39680 First, I imported data ...
    Omkar JoshiOmkar Joshi
    Jul 26, 2013 at 10:01 am
    Jul 26, 2013 at 12:33 pm
  • Hi, I'm running a query like this: CREATE TABLE foo STORED AS ORC AS SELECT id, season, amount, ntile(10) OVER ( PARTITION BY season ORDER BY amount DESC ) FROM bar; On a small enough dataset that ...
    Lars FranckeLars Francke
    Jul 17, 2013 at 9:25 pm
    Jul 25, 2013 at 5:31 pm
  • Hi All, I have installed hive 4 months back, i don't have any database installed in my system. till today it was working fine, but now i'm getting this metadata error... can anyone please suggest me ...
    Maheedhar ReddyMaheedhar Reddy
    Jul 17, 2013 at 6:51 am
    Jul 22, 2013 at 10:56 am
  • Hello, I have just started using Hive and I was trying to create an external table with the csv file placed in NFS. I tried using file:// and local://. Both of these attempts failed with the error ...
    Mainak GhoshMainak Ghosh
    Jul 17, 2013 at 8:26 pm
    Jul 19, 2013 at 5:21 pm
  • i wait long time,no result ,why hive is so slow? hive select cookie,url,ip,source,vsid,token,residence,edate from hb_cookie_history where edate ='1371398400500' and edate<='1371400200500'; Total ...
    Ch huangCh huang
    Jul 19, 2013 at 1:29 am
    Jul 19, 2013 at 9:07 am
  • Hi, Currently, I'm executing the following steps(Hadoop 1.1.2, Hive 0.11 and Sqoop-1.4.3.bin__hadoop-1.0.0) : 1. Import data from MySQL to Hive using Sqoop 2. Execute a query in Hive and store its ...
    Omkar JoshiOmkar Joshi
    Jul 18, 2013 at 5:05 am
    Jul 18, 2013 at 6:14 am
  • Hey all - I was wondering if there were any "shortcut" Java courses out there. As in, I am not looking for a holistic learn everything about Java course, but more of a "So you are a big data/hive ...
    John OmernikJohn Omernik
    Jul 17, 2013 at 7:53 pm
    Jul 17, 2013 at 8:14 pm
  • Hi, I have a UDF that returns a list and another one that returns a list of lists. I am not sure how to read the results back as lists in JDBC/hiveserver1. All I can do is while (rset.next()) { ...
    Kumar VKumar V
    Jul 16, 2013 at 5:16 pm
    Jul 17, 2013 at 3:04 am
  • Hello, Can we (other applications) use HDFS without invoking MapReduce operations? Thanks for your answers.
    Matouk IFTISSENMatouk IFTISSEN
    Jul 15, 2013 at 10:10 am
    Jul 15, 2013 at 10:19 am
  • hi here, I create a table like this and put a lot data into it. then I export query result into csv file like this: hive -e myquery result.csv but the csv uses tab as split. how to make hive use ','? ...
    Kentkong_workKentkong_work
    Jul 10, 2013 at 4:49 am
    Jul 11, 2013 at 12:16 am
  • Hey there, I have been using HIVE(0.7) for a while now using CLI and bash scripts. But its a pain to move cursor in the CLI i.e. once you enter a very long query then you cant go to start of the ...
    Rahul kavaleRahul kavale
    Jul 9, 2013 at 5:31 am
    Jul 9, 2013 at 9:20 pm
  • Hi , The log file that I am trying to load throuh Hive has some special characters The field is shown below and the special characters ¿¿are also shown. Shockwave Flash in;Motive ...
    Raj HadoopRaj Hadoop
    Jul 8, 2013 at 8:52 pm
    Jul 9, 2013 at 6:45 am
  • Hi all, Would anybody have any comments or feedback about the hive local mode execution? It is advertised as providing a boost to performance for small data sets. It seem to fit nicely when running ...
    Guillaume AllainGuillaume Allain
    Jul 1, 2013 at 8:01 am
    Jul 4, 2013 at 3:53 pm
  • Hi, When I installed Hive earlier on my machine I used a oracle hive meta script. Please find attached the script. HIVE worked fine for me on this box with no issues. I am trying to install Hive on ...
    Raj HadoopRaj Hadoop
    Jul 3, 2013 at 8:23 pm
    Jul 3, 2013 at 10:02 pm
  • Hi, My requirement is to load data from a (one column) Hive view to a CSV file. After loading it, I dont see any file generated. I used the following commands to load data to file from a view v_june1 ...
    Raj HadoopRaj Hadoop
    Jul 1, 2013 at 11:02 pm
    Jul 2, 2013 at 2:15 am
  • Hi, I just noted that the CASCADE option is missing in the documentation for partition protection ...
    Jean-Charles ThomasJean-Charles Thomas
    Jul 22, 2013 at 3:20 pm
    Aug 10, 2013 at 11:07 pm
  • Hi Praveen / All, I also have a requirement similar to the one explained (by Praveen) below: distinct rows on a single column with corresponding data from other columns ...
    Sunita ArvindSunita Arvind
    Jul 30, 2013 at 3:00 pm
    Jul 31, 2013 at 12:09 am
  • Clum, JoshClum, Josh
    Jul 29, 2013 at 12:43 pm
    Jul 29, 2013 at 4:06 pm
Group Navigation
period‹ prev | Jul 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions114
posts419
users138
websitehive.apache.org

138 users for July 2013

Jérôme Verdier: 22 posts Ch huang: 21 posts Nitin Pawar: 21 posts Sanjay Subramanian: 20 posts Navis류승우: 12 posts Raj Hadoop: 12 posts Stephen Sprague: 12 posts Matouk IFTISSEN: 11 posts Edward Capriolo: 10 posts j.barrett Strausser: 9 posts Mohammad Tariq: 7 posts Brad Ruderman: 6 posts Omkar Joshi: 6 posts Richa Sharma: 6 posts Bejoy_ks: 5 posts Agateaaa: 5 posts Kulkarni Swarnim: 5 posts Manickam P: 5 posts Michael Malak: 5 posts Peter Marron: 5 posts
show more
Archives