Re: Can not Drop Table/View in Hive

Hello, Just for the record: I ve got my issue resolved. by adding to my hive-site.xml the property: datanucleus.fixedDatastore true But still do not understand how does that impact the metastore :( Amajd On Thu, Jun 18, 2015 at 5:29 PM, Amjad ALSHABANI wrote: > Hello All, >

Can not Drop Table/View in Hive

Hello All, I m having an issue when trying to droping a table (or a view) in hive: I m using Hive0.14, metastore MySql, hadoop 2.4, HDP 2.2.4 when issuing the following command: $ hive -e "use poc_pdd; show tables;" it hangs... when activating the DEBUG (just getting hte last lines from the ou

Re: Hive 0.13/Hadoop 0.20 ORC probleme

wrote: > Both Hadoop 2.6 and hive 0.13 use protobuf 2.5, so it runs well. > But Hadoop 2.0 and before, protobuf 2.4 is used, just as I mentioned > before, 2.4 and 2.5 are uncompatible. > > Good luck. > > On Thu, Dec 11, 2014 at 10:22 PM, Amjad ALSHABANI > wrote: >> &g

Re: Hive 0.13/Hadoop 0.20 ORC probleme

: > hi，Amjad > > protobuf 2.4 isn't compatible with protobuf 2.5, so you should regen > OrcProto.java using protobuf 2.4.0, and then rebuild hive. > > I hope it helps. > > > > On Wed, Dec 10, 2014 at 6:28 PM, Amjad ALSHABANI > wrote: >> >> Hell

Hive 0.13/Hadoop 0.20 ORC probleme

Hello everybody. I have a problem when using ORC file format in Hive 0.13. I have built Hive 0.13 with Hadoop 0.20. when creating a table using ORC format it is OK, but when trying to add some lines or do a simple count I got this exception: java.lang.VerifyError: class org.apache.hadoop.hive.ql

Re: HDFS Overwriting undo

zad, I am afraid u can't > > Sent from my iPhone > > On May 30, 2014, at 3:12 AM, "Amjad ALSHABANI" > wrote: > > Hello Everybody, > > I know that this question may concern Hadoop list but i ve made this > mistake when using Hive. > I created new datab

Re: HDFS Overwriting undo

his command: > hadoop fs -ls -lrt /user/hive/warehouse/ > > Regards. > > > On Fri, May 30, 2014 at 6:10 AM, Amjad ALSHABANI > wrote: > >> Hello Everybody, >> >> I know that this question may concern Hadoop list but i ve made this >> mistake when using Hive

HDFS Overwriting undo

Hello Everybody, I know that this question may concern Hadoop list but i ve made this mistake when using Hive. I created new database giving the location on HDFS but i found that it removed all other data that exist already. = before creation, the directory on HDFS contains : pns@app11:~$ ha

Re: HiveServer2 with Hive CLI

You are using the default Derby metastore? > > There shouldn’t be any problem opening multiple connections to MySQL, > Oracle or Postgres. > > > > > > *From:* Amjad ALSHABANI [mailto:ashshab...@gmail.com] > *Sent:* Wednesday, May 28, 2014 11:42 AM > *To:* user@hive.apac

HiveServer2 with Hive CLI

Hello everybody, I m trying to start hiveserver2 to connect to hive via a PHP application, but in the same time I would like to keep connecting Hive CLI ( hive> ) on the same machine to execute some request manually. It seems that it is not possilbe to do so (the Hive thrift server seems to lock

Re: Disabeling log in Hive 0.10

I just want to mention that this Hive request requires multi M/R jobs , and the log progressing is disabled just for the first job so the question now, is it possible to disable the querylog progression for all the jobs Thanx in advance B.R Amjad On Wed, Apr 23, 2014 at 4:59 PM, Amjad

Disabeling log in Hive 0.10

Hello Everybody, Firstly, I will be clear that I m using *Hive 0.10* and I do not have the choice to use more recente release. When starting a hive request the log file size increases extremely, exceeding 3GB I want to disable wriritng to this log file (this one whichi is difined by the proeprty:

Re: Number of Mapper when reading from Cassandra

ffset of block2), > f2(offest of block3), > f2(offset of block4) > Other InputFormat has its own methods for files splitting (for example > Hbase splits input on region boundaries). > > > Hope It Helps, > Chinna > > > On Fri, Mar 28, 2014 at 4:47 PM, Amjad ALSHABANI

Number of Mapper when reading from Cassandra

Hello All, I have tow tables created in Hive, one read the data immidiately from Cassandra DB and the other takes the data from stored files (data already exported in somewhow from the same Cassandra DB) Both tables are identical (in data) but when running the same request it gives me very differ

Multiple group-by Inserts

Hello , I m trying to get some statistics using Hive and insert them into new table Those statics are the count of each field on another table grouped by the column "usrlvl" I need to do all of that in single request, so I ve googled how to do that and found the following link https://cwiki.apac