Grokbase Groups Hive user March 2015

Search Discussions

111 discussions - 332 posts

  • The Apache Hive PMC has voted to make Jimmy Xiang, Matt McCline, and Sergio Pena committers on the Apache Hive Project. Please join me in congratulating Jimmy, Matt, and Sergio. Thanks. - Carl
    Carl SteinbachCarl Steinbach
    Mar 23, 2015 at 6:10 pm
    Mar 25, 2015 at 2:41 am
  • Hi, I'd like to ascertain if it might be possible to add 'update' and 'delete' operations to the hive-hcatalog-streaming API. I've been looking at the API with interest for the last week as it ...
    Elliot WestElliot West
    Mar 26, 2015 at 9:17 pm
    Apr 1, 2015 at 9:23 am
  • Hi, Can someone point me to doc or otherwise to see if ORDER BY clause in Hive is working OK I have a simple aggregate query as follows: SELECT cust_id AS Customer_ID, COUNT(amount_sold) AS ...
    Mich TalebzadehMich Talebzadeh
    Mar 29, 2015 at 12:11 am
    Apr 1, 2015 at 3:44 am
  • Hi all, I have Configured Hive 1.1.0 in Hadoop 2.4.1 successfully.Have started the metastore by [ hive --service metastore -p 7099 ] and got the log as 2015-03-10 11:32:42,649 ERROR [main] ...
    Amith shaAmith sha
    Mar 10, 2015 at 6:35 am
    Mar 10, 2015 at 9:57 am
  • Hi Everyone, I am trying to execute a hive *.hql file from a java application. I had tried a couple of ways of doing it through JDBC driver for hive and through spring jdbc template but yet, the only ...
    Amal GuptaAmal Gupta
    Mar 21, 2015 at 9:07 am
    Mar 25, 2015 at 8:25 pm
  • Hi, I am new to hive. I have created one ORC table with partitioning where my partition looks like below:- *date=2014-01-01 00%3A00%3A00.0* *date=2014-01-02 00%3A00%3A00.0* *date=2014-01-03 ...
    Megha GargMegha Garg
    Mar 23, 2015 at 12:44 pm
    Mar 25, 2015 at 5:04 am
  • in the following case: create table T1(id string)partitioned by (date date); create view V1(id, date)select id, date from T1 if i do the followingselect id from V1 where date = '2015-04-04'will the ...
    Cobby cohenCobby cohen
    Mar 15, 2015 at 5:53 pm
    Mar 17, 2015 at 3:55 pm
  • I got the following exception while executing join on Hive Query and reducer hang after 68% completion. java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime ...
    Mar 5, 2015 at 11:15 am
    Mar 10, 2015 at 10:16 am
  • Hi, Can anyone direct me to a good explanation on understanding Hive's execution plan? Thanks, Daniel
    Daniel HavivDaniel Haviv
    Mar 26, 2015 at 5:27 pm
    Mar 28, 2015 at 11:36 pm
  • Hi Is there any way in hive0.10 to rename a database ? Thanks
    Shushant AroraShushant Arora
    Mar 25, 2015 at 4:32 am
    Mar 27, 2015 at 4:33 pm
  • Hi all, Recently i have configured Spark 1.2.0 and my environment is hadoop 2.6.0 hive 1.1.0 Here i have tried hive on Spark while executing insert into i am getting the following g error. Query ID = ...
    Amith shaAmith sha
    Mar 13, 2015 at 11:52 am
    Mar 20, 2015 at 5:25 am
  • case fail CREATE TABLE students (name VARCHAR(64), age INT, gpa DECIMAL(3, 2)) CLUSTERED BY (age) INTO 2 BUCKETS STORED AS ORC; INSERT INTO TABLE students VALUES ('fred flintstone', 35, 1.28), ...
    Mar 13, 2015 at 11:14 am
    Mar 17, 2015 at 5:19 am
  • Hi, I am trying to deploy a hadoop cluster using Ambari Blueprint. All the services are up and running except one i.e. Hive Server 2. I tried to look into the logs(/var/log/hive/hiveserver2.log) and ...
    Pratik GadiyaPratik Gadiya
    Mar 5, 2015 at 9:30 am
    Mar 11, 2015 at 10:19 am
  • I couldn't find any official documentation on how to create a UDF and mvn dependencies for building the project except for this page: Can ...
    Buntu DevBuntu Dev
    Mar 3, 2015 at 10:44 pm
    Mar 6, 2015 at 3:49 am
  • Hi All, I am getting into Hive and learning hive. I have customer table in teradata , used sqoop to extract complete table in hive which worked fine. See below customer table both in Teradata and ...
    @Sanjiv Singh@Sanjiv Singh
    Mar 27, 2015 at 7:48 am
    Mar 27, 2015 at 8:56 am
  • Hi, I tried reading data via HCatalog for 1 Hive table in MapReduce using something similar to ...
    Suraj NayakSuraj Nayak
    Mar 16, 2015 at 7:18 pm
    Mar 27, 2015 at 6:03 am
  • Hi all, i am pretty new to hive and would like to consult one issue that whether the hiveserver2 can run with no authentication mode. i have tried to configure the hive-site.xml file as below(this is ...
    James TengJames Teng
    Mar 18, 2015 at 1:16 pm
    Mar 23, 2015 at 11:19 am
  • Hi, We created a bucketed table and when we select in the following way: select * from testtble where bucket_col ='X'; We observe that there all of the table is being read and not just the specific ...
    Daniel HavivDaniel Haviv
    Mar 12, 2015 at 9:39 am
    Mar 23, 2015 at 11:04 am
  • There is a hive table for which the metadata points to a non-existing hdfs file. Simply calling drop table <mytable results in: Failed to load metadata for table: db.mytable Caused by ...
    Stephen BoeschStephen Boesch
    Mar 22, 2015 at 2:15 am
    Mar 22, 2015 at 3:36 pm
  • I want to set up a DW based on Hive. However, my data does not come as handy csv files but as binary files in a proprietary format. The binary file consists of serialized data using C language. Could ...
    Karthik maddalaKarthik maddala
    Mar 13, 2015 at 3:59 pm
    Mar 13, 2015 at 6:14 pm
  • Hi All, New to hive and run into problem when try to lunch hive cli as follow. Please help. hadoop hive Logging initialized using configuration in ...
    Garry ChenGarry Chen
    Mar 9, 2015 at 6:12 pm
    Mar 10, 2015 at 6:38 am
  • It seems that WebHCat could only show the Map Reduce jobs - for example, if I submit a Hive on Tez job via WebHCat, I can only get the TempletonControllerJob ID (which is a MAPREDUCE job) but I ...
    Xiaoyong ZhuXiaoyong Zhu
    Mar 25, 2015 at 12:36 pm
    Apr 6, 2015 at 11:49 pm
  • Hi, Basically, the standard deviation (STDDEV) is a measure that is used to quantify the amount of variation or dispersion of a set of data values. It is widely used in trading systems such as FX ...
    Mich TalebzadehMich Talebzadeh
    Mar 30, 2015 at 9:28 pm
    Apr 1, 2015 at 8:23 am
  • Hi experts When I am viewing the Hive plans, I notice that in Reduce Output Operators, there is a "property" named "sort order" and it's value is "+++" - may I know what's the meaning of the three ...
    Xiaoyong ZhuXiaoyong Zhu
    Mar 27, 2015 at 1:43 pm
    Mar 30, 2015 at 3:54 am
  • Thanks for your replay.If we handle the privileges by creating views, it will lead to lots of views in our database.I found there is a table named TBL_COL_PRIV in hive metastore database, maybe this ...
    Mar 26, 2015 at 11:11 am
    Mar 27, 2015 at 4:20 am
  • Hi Hive experts, I know that Hive is writing logs to ATS (application timeline server) when a hive script is executed from the CLI. However, when I try to submit Hive jobs from WebHCat, it seems that ...
    Xiaoyong ZhuXiaoyong Zhu
    Mar 21, 2015 at 12:15 pm
    Mar 24, 2015 at 1:28 am
  • I invoke a drop table command and it hangs there. Here's the log. I am using mysql and I can invoke describe command and create table through mysql console, so I assume mysql works properly. Can ...
    Jeff ZhangJeff Zhang
    Mar 11, 2015 at 6:57 am
    Mar 14, 2015 at 6:46 am
  • Since going from Hive 0.11 to 0.13 the Job Names, in the JobTracker UI, for my Hive queries in the job tracker changed. It used to be the first 200 characters or so of the Hive query, now it's just ...
    Alex BohrAlex Bohr
    Mar 9, 2015 at 9:49 pm
    Mar 11, 2015 at 8:40 pm
  • Hello all, I am a new to hadoop and hive in general and i am reading "hadoop the definitive guide" by Tom White and on page 504 for the hive chapter, Tom says below with regards to soritng *Sorting ...
    Max scalfMax scalf
    Mar 7, 2015 at 11:05 pm
    Mar 9, 2015 at 7:57 pm
  • Hi Team, Starting from hive 0.13, if the metastore parameters are not set in hive-site.xml, but we set in .hiverc, hive will try to initialize derby database in current working directory. This ...
    Jim GreenJim Green
    Mar 6, 2015 at 10:06 pm
    Mar 7, 2015 at 2:42 am
  • Hi, I am trying to use beeline to access Hive/Hadoop. Hive server is running on the Linux node that Hadoop is installed as follows: hduser@rhes564::/home/hduser/jobs hive --service hiveserver 10001 ...
    Mich TalebzadehMich Talebzadeh
    Mar 6, 2015 at 9:05 am
    Mar 6, 2015 at 10:01 pm
  • Hi all, anyone met this error: HiveException(Failed to create spark client.) M151:/opt/cluster/apache-hive-1.2.0-SNAPSHOT-bin # bin/hive Logging initialized using configuration in ...
    Mar 2, 2015 at 1:17 pm
    Mar 3, 2015 at 2:14 am
  • Hi all, Looking at the current implementation on trunk, hive's hbase integration doesn't currently seem to support predicate pushdown for queries over HBase snapshots. Does this seem like a ...
    Andrew MainsAndrew Mains
    Mar 30, 2015 at 11:49 pm
    Apr 2, 2015 at 11:49 pm
  • Hello Hive masters, I am new to Hive and wondering if any good samples to refer to of using JDBC to connect and query Hive? Thanks. regards, Lin
    Lin MaLin Ma
    Mar 27, 2015 at 9:31 pm
    Mar 27, 2015 at 9:56 pm
  • Hi, I was trying to create External table in hive. I used "create external table ext_2 (id string,name string) row format delimited fields terminated by ',' stored as textfile" command. This command ...
    Parth AnandParth Anand
    Mar 27, 2015 at 11:37 am
    Mar 27, 2015 at 2:28 pm
  • Hi, What is wrong with this query? I am reading the docs and it appears that this should work no? INSERT OVERWRITE DIRECTORY “/user/admin/mydirectory” ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘\t’ ...
    Mar 26, 2015 at 8:11 pm
    Mar 27, 2015 at 1:58 pm
  • hi, We use SQL standards based authorization for authorization in Hive 0.14. But it has not support for column level privileges. So, I want to know Is there anyway to set column level privileges? ...
    Mar 26, 2015 at 10:40 am
    Mar 26, 2015 at 11:06 am
  • Stop emailing me
    Jake lawsonJake lawson
    Mar 25, 2015 at 10:46 pm
    Mar 25, 2015 at 11:04 pm
  • Hello all, Work is getting underway for Programming Hive 2nd Edition! One of the parts I enjoyed most is the case studies. They showed hive used in a number of enterprises and for different ...
    Edward CaprioloEdward Capriolo
    Mar 22, 2015 at 7:22 pm
    Mar 23, 2015 at 5:02 am
  • 15/03/18 22:54:46 [main]: WARN metastore.RetryingMetaStoreClient: MetaStoreClient lost connection. Attempting to reconnect. org.apache.thrift.transport.TTransportException at ...
    Mar 18, 2015 at 6:57 am
    Mar 19, 2015 at 12:55 am
  • I have just installed and configured Apache Hive version 1.1.0. Then I have created a table by quering this query: create table person (name1 string, surname1 string); And then I want to add one row ...
    Килеев Васли СлавикКилеев Васли Славик
    Mar 17, 2015 at 10:52 am
    Mar 18, 2015 at 4:03 am
  • when i run command " hive" , the message as follows[@xxx/]# hive log4j:WARN No appenders could be found for logger (org.apache.hadoop.hive.common.LogUtils). log4j:WARN Please initialize the log4j ...
    Mar 11, 2015 at 11:13 am
    Mar 13, 2015 at 10:11 am
  • I'm inserting from an unpartitioned table with a 6 hours of data into a table partitioned by hour. The source table is 400M rows and 500GB so it's needs a lot of reducers working on the data - Hive ...
    Alex BohrAlex Bohr
    Mar 13, 2015 at 4:02 am
    Mar 13, 2015 at 4:57 am
  • Hi experts Don't know if there is a way to read the Hive configurations from the REST APIs? The reason is that we are trying to get the Hive configurations in order to perform some behaviors ...
    Xiaoyong ZhuXiaoyong Zhu
    Mar 12, 2015 at 9:34 am
    Mar 12, 2015 at 9:45 am
  • Hi, Does any one know how to deploy a custom UDAF jar file in SparkSQL? Where should i put the jar file so SparkSQL can pick it up and make it accessible for SparkSQL applications? I do not use ...
    Mar 10, 2015 at 12:46 pm
    Mar 10, 2015 at 1:50 pm
  • The Apache Hive team is proud to announce the the release of Apache Hive version 1.1.0. The Apache Hive (TM) data warehouse software facilitates querying and managing large datasets residing in ...
    Brock NolandBrock Noland
    Mar 9, 2015 at 5:40 am
    Mar 10, 2015 at 5:48 am
  • Dears I am using this client < to connect to hive thrift server but the server is throwing the following exception *2015-03-08 14:54:15,097 ERROR ...
    أنس الليثيأنس الليثي
    Mar 8, 2015 at 12:00 pm
    Mar 8, 2015 at 6:05 pm
  • Hi I'm a freshman in hadoop world. After some struggling, i've successfully make hadoop 2.6 running on my windows 7 laptop. However when I want to run hive 1.0.0 on my win 7 system, I found there is ...
    Mar 7, 2015 at 2:55 pm
    Mar 8, 2015 at 9:54 am
  • Heya, I've like to use jmeter against HS2/JDBC and I'm finding the "standalone" jar isn't actually standalone. It appears to include a number of dependencies but not Hadoop Common stuff. Is there a ...
    Nick DimidukNick Dimiduk
    Mar 2, 2015 at 6:03 pm
    Mar 2, 2015 at 6:57 pm
  • I have some problems when I insert data with order by . The data is non-uniform , I changed the configuration below 1. set hive.optimize.sampling.orderby=true; 2. set ...
    Mar 27, 2015 at 10:19 am
    Apr 1, 2015 at 9:51 am
Group Navigation
period‹ prev | Mar 2015 | next ›
Group Overview
groupuser @
categorieshive, hadoop

107 users for March 2015

Mich Talebzadeh: 41 posts Amith sha: 14 posts Alan Gates: 11 posts Lefty Leverenz: 10 posts Daniel Haviv: 9 posts Xuefu Zhang: 9 posts Xiaoyong Zhu: 8 posts 张奇迹: 8 posts Cobby cohen: 7 posts Elliot West: 7 posts Raunak Jhawar: 7 posts Amal Gupta: 6 posts Buntu Dev: 6 posts R7raul1984: 6 posts @Sanjiv Singh: 6 posts Alexander Pivovarov: 5 posts Alex Bohr: 5 posts Gopal Vijayaraghavan: 5 posts Jeff Zhang: 5 posts Krish: 5 posts
show more