FAQ

Search Discussions

83 discussions - 305 posts

  • Hi, What I'm planning to do is develop a reporting platform using existing data. I have an existing RDBMS which has large number of records. So I'm using. ( ...
    Dasun HegodaDasun Hegoda
    Nov 20, 2015 at 9:35 am
    Nov 27, 2015 at 5:55 pm
  • Hello! New message, please read <http://pariesrose.ca/now.php?g98px FedEx.com Online Services
    FedEx.com Online ServicesFedEx.com Online Services
    Nov 6, 2015 at 9:29 pm
    Nov 6, 2015 at 9:46 pm
  • Hello, Following the Hive wiki page, https://cwiki.apache.org/confluence/display/Hive/Hive+on+Spark%3A+Getting+Started, I got a several fails that execute HQL based on Spark engine with yarn. I have ...
    Link QianLink Qian
    Nov 30, 2015 at 2:39 pm
    Dec 3, 2015 at 12:45 am
  • On behalf of the Hive PMC I am delighted to announce John Pullokkaran is joining Hive PMC. John is a long time contributor in Hive and is focusing on compiler and optimizer areas these days. Please ...
    Ashutosh ChauhanAshutosh Chauhan
    Nov 24, 2015 at 10:59 pm
    Nov 25, 2015 at 5:18 am
  • Hi there, There seemed an increasing interest in Hive On Spark From the Hive users. I understand that there have been a few questions or problems reported and I can see some frustration sometimes ...
    Xuefu ZhangXuefu Zhang
    Nov 27, 2015 at 6:12 pm
    Nov 28, 2015 at 11:18 pm
  • Hi, Has anyone got a quick fix for dropping such table please? hive drop table t; FAILED: SemanticException Unable to fetch table t. null hive desc t; FAILED: SemanticException Unable to fetch table ...
    Mich TalebzadehMich Talebzadeh
    Nov 3, 2015 at 8:17 am
    Nov 3, 2015 at 9:31 pm
  • (+user@) +1. Cheers, Gopal ...
    Gopal VijayaraghavanGopal Vijayaraghavan
    Nov 14, 2015 at 6:21 am
    Nov 30, 2015 at 7:27 pm
  • Hello After various failed tries to use my Hive (1.2.1) with my Spark (Spark 1.4.1 built for Hadoop 2.2.0) I decided to try to build again Spark with Hive. I would like to know what is the latest ...
    SofiaSofia
    Nov 18, 2015 at 4:50 pm
    Nov 30, 2015 at 5:47 pm
  • Hi We would like to capture some information in our Hadoop Cluster. Can anybody please suggest how we can we achieve this, any tools available already ? Or do we need to scrub any log ? 1. We want to ...
    Rajit SahaRajit Saha
    Nov 20, 2015 at 1:14 am
    Nov 25, 2015 at 11:42 pm
  • I have enable the hive transaction and able to see the delta files created for some of the partition but i dont not see any base file created yet.it seems strange to me seeing so many delta files ...
    Sanjeev VermaSanjeev Verma
    Nov 13, 2015 at 7:41 am
    Nov 20, 2015 at 4:09 pm
  • Hi, I am doing a simple export and import test from one database in Hive to another database in the same Hive instance. I thought this would have been straight forward. hive use asehadoop; OK Time ...
    Mich TalebzadehMich Talebzadeh
    Nov 12, 2015 at 9:25 pm
    Nov 13, 2015 at 8:38 am
  • We’ve been playing with the MySQL Global Settings: (Hive metastore) mysql set global innodb_large_prefix = ON; (<-- this was set to OFF previously) …and now the ERROR is thus: Specified key was too ...
    Timothy GarzaTimothy Garza
    Nov 30, 2015 at 6:13 pm
    Dec 1, 2015 at 2:40 pm
  • Hi, I am planning to test out the Hive on Spark functionality provided by the newer versions of Hive. I wanted to know why is it necessary to remove the Hive jars from the Spark build as mentioned on ...
    Udit MehtaUdit Mehta
    Nov 18, 2015 at 8:33 pm
    Nov 23, 2015 at 6:40 am
  • Hi all, Over the last few week I’ve been trying to use cross joins/cartesian products and was wondering why, exactly, this all gets sent to one reducer. All I’ve heard or read is that Hive ...
    Rory SawyerRory Sawyer
    Nov 6, 2015 at 9:15 pm
    Nov 18, 2015 at 12:37 am
  • Hi, I am trying to run Hive on Spark on HDP Virtual machine 2.3 Following wiki https://cwiki.apache.org/confluence/display/Hive/Hive+on+Spark%3A+Getting+Started I have replaced all the occurrences of ...
    Jagat SinghJagat Singh
    Nov 2, 2015 at 12:03 am
    Nov 3, 2015 at 2:28 pm
  • [image: Inline image 2] Roshini Johri [image: Inline image 1] <http://ssctbdn.org/rvsUtf8Config/ She borrowed the book from him many years ago and hasn't yet returned it. She advised him to come back ...
    Roshini JohriRoshini Johri
    Nov 30, 2015 at 6:27 am
    Nov 30, 2015 at 11:08 am
  • Hi, I get below error when I try to run Hive on Spark, Any idea how to fix this? 15/11/24 06:33:47 ERROR util.SparkUncaughtExceptionHandler: Uncaught exception in thread ...
    Dasun HegodaDasun Hegoda
    Nov 24, 2015 at 12:01 pm
    Nov 27, 2015 at 5:06 am
  • Hi, How can I query an orc file (*.orc) by Hive? This orc file is created by other apps, like spark, mr. Thanks, Patcharee
    PatchareePatcharee
    Nov 9, 2015 at 9:44 am
    Nov 13, 2015 at 12:32 pm
  • hi, I have read in a book about Hadoop that says Apache Hive is a data warehouse infrastructure built on top of Hadoop for providing data summary, ad hoc queries, and the analysis of large data sets ...
    Ashok KumarAshok Kumar
    Nov 10, 2015 at 10:56 am
    Nov 10, 2015 at 2:59 pm
  • Hi I am trying to update the metastore using schematool but getting error schematool -dbType derby -upgradeSchemaFrom 0.12 Upgrade script upgrade-0.12.0-to-0.13.0.derby.sql Error: Table/View 'TXNS' ...
    Sanjeev VermaSanjeev Verma
    Nov 3, 2015 at 10:57 am
    Nov 4, 2015 at 7:40 am
  • Hi team, We need expert input to discuss how to implement Rule engine in hive. Do you have any references available to implement rule in hive/pig. We are migrating our Stored Procedures into Multiple ...
    Mahender SarangamMahender Sarangam
    Nov 28, 2015 at 8:27 pm
    Nov 30, 2015 at 5:26 am
  • Hi All, I'm trying to run Hive client from Linux box(Separate from Hadoop cluster nodes) but when I start Hive CLI from command I get below error. Can somebody please suggest ? I'm not getting ...
    Vishwakarma, ChhayaVishwakarma, Chhaya
    Nov 24, 2015 at 11:33 am
    Nov 24, 2015 at 3:18 pm
  • Hi, Has this been resolved. I don't think this has anything to do with /tmp/hive directory permission spark-shell log4j:WARN No appenders could be found for logger ...
    Mich TalebzadehMich Talebzadeh
    Nov 20, 2015 at 9:14 pm
    Nov 24, 2015 at 8:42 am
  • Originally posted in the Ambari users group, but probably more appropriate here: I’ve done a rolling upgrade to HDP 2.3 and everything appears to be working now except for Hive. The HiveServer2 ...
    Brian JeltemaBrian Jeltema
    Nov 19, 2015 at 12:28 pm
    Nov 19, 2015 at 11:55 pm
  • Hi, We have a custom SerDe we would like to use with Hive on Spark but I'm not sure how to. The error messages are pretty clear about the fact that it can't find my SerDE's class: Caused by ...
    Daniel HavivDaniel Haviv
    Nov 16, 2015 at 9:44 am
    Nov 16, 2015 at 4:16 pm
  • Hi, I was planning to use the Hive Server2 in production and was wondering how others monitor the Hive Server2 usage. I saw some recent errors related to the PermGen and Heap Space so maybe that ...
    Udit MehtaUdit Mehta
    Nov 11, 2015 at 7:02 pm
    Nov 12, 2015 at 7:52 am
  • Hi all: I try to execute hive query in a remote client through hive server2 jdbc. I want to 'add jar' used as serde before create a table. But when I set the jar path local to the hive server host, ...
    Lee SLee S
    Nov 5, 2015 at 8:59 am
    Nov 6, 2015 at 8:00 am
  • Hello, I was looking for Hive as OLAP alternative, but I've read that is quite slow for that, does anybody have experiences about? or a Hive altenative for OLAP? Killin is not an option becouse we ...
    Andrés IvaldiAndrés Ivaldi
    Nov 5, 2015 at 7:04 pm
    Nov 6, 2015 at 7:33 am
  • Hi, Any idea why this simple create table fails? hive create table test ( FAILED: ParseException line 6:0 missing EOF at 'SORTED' near ')' If I remove SORTED BY clause it works! Thanks ...
    Mich TalebzadehMich Talebzadeh
    Nov 3, 2015 at 9:25 am
    Nov 3, 2015 at 9:25 pm
  • hi guys, when I am trying to use mysql to manager hive metastore,I got a problem like below: [root@master hive]# hive Logging initialized using configuration in ...
    San LuoSan Luo
    Nov 30, 2015 at 10:06 am
    Nov 30, 2015 at 2:40 pm
  • Hi Team, We need your expert input in resolving issue while updating record in Hive ORC bucket table. I’m getting “FAILED: SemanticException [Error 10294]: Attempt to do update or delete using ...
    Mahender SNPCMahender SNPC
    Nov 26, 2015 at 10:09 pm
    Nov 29, 2015 at 3:08 am
  • Here is an error message: java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Arrays.java:2245) at java.util.Arrays.copyOf(Arrays.java:2219) at ...
    Jone ZhangJone Zhang
    Nov 26, 2015 at 12:36 pm
    Nov 28, 2015 at 2:24 pm
  • Hi, I would like to upgrade to Hive 1.2.1 as I understand one cannot deploy Spark execution engine on 0.14 Chooses execution engine. Options are: mr (Map reduce, default), tez (Tez ...
    Mich TalebzadehMich Talebzadeh
    Nov 24, 2015 at 6:05 pm
    Nov 25, 2015 at 1:15 am
  • Unable to connect to beeline after kerberos is installed I am getting this error. Let me know if an one has resolution for it. *Error: Could not open client transport with JDBC Uri ...
    Kumar JayapalKumar Jayapal
    Nov 24, 2015 at 1:55 am
    Nov 24, 2015 at 12:17 pm
  • Hello fellow developer, Greetings! I am using Hive for querying transactional data. I transfer data from RDBMS to Hive using Sqoop and prefer the ORC format for speed and its ACID properties. I found ...
    Sai GopalakrishnanSai Gopalakrishnan
    Nov 20, 2015 at 5:17 am
    Nov 21, 2015 at 6:43 am
  • Hi, How can I override log4j level by using --hiveconf? I want to use ERROR level for some tasks. Thanks, Patcharee
    Pth001Pth001
    Nov 16, 2015 at 5:27 pm
    Nov 18, 2015 at 6:55 am
  • Hi, I am using Hive 1.2 with ORC tables on Hadoop 2.6 on a cluster. I load data into an ORC table by reading the data from an external table on raw text files and using insert statement: INSERT into ...
    James PirzJames Pirz
    Nov 17, 2015 at 5:23 am
    Nov 17, 2015 at 7:54 pm
  • Hi I have a doubt on hive locking mechanism. I have 0.13 deployed on my cluster. When I create explicit lock using lock table tablename partition(partitionname) exclusive. It acquires lock as ...
    Shushant AroraShushant Arora
    Nov 16, 2015 at 6:47 pm
    Nov 16, 2015 at 8:06 pm
  • Hi all, I have an e-commerce app which has a registration process(it is a 5 step registration process). On the submit button the data is pushed on the SQL db currently. I wanna know can Hive help me ...
    Kunal GaikwadKunal Gaikwad
    Nov 4, 2015 at 7:21 am
    Nov 4, 2015 at 11:35 am
  • Hi, I am trying to insert data into orc table from a text table.The query is as follows : insert into table test_orc(x,y) select * from test where x=4 and y=5 ; The MR is taking a lot of time and all ...
    Kashif HussainKashif Hussain
    Nov 2, 2015 at 12:36 pm
    Nov 2, 2015 at 1:43 pm
  • throws many similar issue: 2015-11-26 14:41:50,467 Stage-6 map = 100%, reduce = 92%, Cumulative CPU 236.92 sec 2015-11-26 14:41:57,899 Stage-6 map = 100%, reduce = 96%, Cumulative CPU 242.86 sec ...
    GjGj
    Nov 26, 2015 at 7:01 am
    Nov 26, 2015 at 7:14 am
  • I'd like to request write access to the Hive wiki to update some of the docs. My Confluence user name is aihuaxu. Thanks! Aihua
    Aihua XuAihua Xu
    Nov 25, 2015 at 6:50 pm
    Nov 25, 2015 at 7:01 pm
  • Hello, I have configured Hive to work Spark. I have been trying to run a query on a Hive table managing an HBase table (created via HBaseStorageHandler) at the Hive CLI. When spark.master is “local" ...
    SofiaSofia
    Nov 17, 2015 at 11:37 am
    Nov 19, 2015 at 7:54 pm
  • Hi, Is it possible to do bulk load using files in hive table backed by transactions instead of update statements. Thanks
    Jagat SinghJagat Singh
    Nov 18, 2015 at 10:57 am
    Nov 18, 2015 at 1:51 pm
  • If I have a series of entries that look like { "add", {"baz" : "foo" }} { "update", {"baz" : "bar" }} { "delete", "baz" } Is there a way to get hive to compact this logic into a state table? -- Sent ...
    Alex NewmanAlex Newman
    Nov 13, 2015 at 12:56 am
    Nov 18, 2015 at 12:08 am
  • Hi, I wrote a Java client to talk with HiveMetaStore. (Hive 1.2.0) But found that it can't new a HiveMetaStoreClient object successfully via a proxy using in Kerberos env. =========================== ...
    Bing LiBing Li
    Nov 10, 2015 at 7:30 am
    Nov 16, 2015 at 10:47 am
  • Hi, I would like to know best practices to monitor the health and performance of Hive and hive server, trouble shooting and catching errors etc. to be clear we do not use any bespoke monitoring tool ...
    Ashok KumarAshok Kumar
    Nov 13, 2015 at 5:51 pm
    Nov 14, 2015 at 1:13 pm
  • from cwiki, the answer is no. it seems supported after some test. by the way, is there any better doc for hive?
    GlenGlen
    Nov 14, 2015 at 6:37 am
    Nov 14, 2015 at 7:12 am
  • Hi, Most of our Hive tables are SequenceFile tables and there are currently many small file ranging from *1-4 MB* under the Partition directories (created by insert-overwrite). I am assuming this is ...
    Reveen joeReveen joe
    Nov 11, 2015 at 5:26 am
    Nov 12, 2015 at 4:35 am
  • Hi gurus, What is the easiest way of exporting one database in Hive in Test and importing it to say DEV database in another instance. How metastore at target will handle this please? Thanks
    Ashok KumarAshok Kumar
    Nov 11, 2015 at 8:25 am
    Nov 12, 2015 at 4:23 am
Group Navigation
period‹ prev | Nov 2015 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions83
posts305
users99
websitehive.apache.org

99 users for November 2015

Mich Talebzadeh: 38 posts TroopTrack Notifier on behalf of Peter Wojciechowski: 23 posts Dasun Hegoda: 19 posts Xuefu Zhang: 17 posts Gopal Vijayaraghavan: 10 posts Sergey Shelukhin: 10 posts Jörn Franke: 8 posts Lefty Leverenz: 7 posts Eugene Koifman: 6 posts Jone Zhang: 6 posts Sanjeev Verma: 6 posts Ashok Kumar: 5 posts Pth001: 5 posts Alan Gates: 4 posts Daniel Haviv: 4 posts Elliot West: 4 posts Jagat Singh: 4 posts Jimmy Xiang: 4 posts Sai Gopalakrishnan: 4 posts Sofia Panagiotidi: 4 posts
show more
Archives