AW: Build hwi of hive 0.14.0 failed

I filed a Bug for it  . HIVE-8953 This broken dependency has been removed later in 0.14 branch.   IMHO  a bugfix release 0.14.1 is needed, otherwise we need to cherry pick patches from this branch in BIGTOP-1543   Olaf     Von: guxiaobo1982 [mailto:guxiaobo1...@qq.com] Gesendet: Samstag, 29.

Re: hive transactions

Thanks unmesha for the detailed article, I have set the required configurations correctly but still the error remains!.. I also see this warning in the trace [ WARN metastore.RetryingMetaStoreClient: MetaStoreClient lost connection. Attempting to reconnect.] don't know why this only occurs when I s

Re: How to retriew data from a specific bucket in hive?

Any pointers would appreciate. On Mon, Dec 1, 2014 at 11:27 AM, unmesha sreeveni wrote: > > On Mon, Dec 1, 2014 at 11:15 AM, yogendra reddy > wrote: > >> hive --orcfiledump > > > ​Hi yogendra​ > > ​shows ​ > Exception in thread "main" java.io.IOException: Malformed ORC file > /employeeData/empL

Re: issue with hive wide tables/views

Any help will be appreciate here. This issue becomes a bigger pain when you have a VIEW referencing another VIEW(s) which have 1000s of columns. It seems the generation of the query plan has some un-optimized code path when there are 1000s of columns. A jstack of a running process ( > 30 minutes

Re: hive transactions

Hi yogendra, I have tried the same thing and I wrote a doc on ACID properties. http://unmeshasreeveni.blogspot.in/2014/11/updatedeleteinsert-in-hive-0140.html Please follow that steps. let me know if that stucks you in any point On Mon, Dec 1, 2014 at 10:49 AM, yogendra reddy wrote: > Hi All

Re: How to retriew data from a specific bucket in hive?

On Mon, Dec 1, 2014 at 11:15 AM, yogendra reddy wrote: > hive --orcfiledump ​Hi yogendra​ ​shows ​ Exception in thread "main" java.io.IOException: Malformed ORC file /employeeData/empLargenew.txt. Invalid postscript. ​But ​my file is not ORC format it is .csv format *1,Anne,Admin,5,A* *2,

Re: How to retriew data from a specific bucket in hive?

Hi, "When I did a -cat, It is not in human readable format" -This is because the file format is specified as orc in your table definition let me know if this works for you (orc file dump utility) hive --orcfiledump Thanks, Yogendra On Mon, Dec 1, 2014 at 10:49 AM, Somnath Pandeya < somnath_pan

Re: How to retriew data from a specific bucket in hive?

On Mon, Dec 1, 2014 at 10:49 AM, Somnath Pandeya < somnath_pand...@infosys.com> wrote: > –cat /user/hive/warehouse/hivemb/delta_012_012/bucket_0/ ​Hi ​Somnath That is not working for me showing something like `J�lj�(��rwNj��[��Y���gR�� \�B�Q_Js)�6 �st�A�6�ixt� R � ޜ�KT� eIL Iԋ�

RE: How to retriew data from a specific bucket in hive?

Hi Unmesha, You can simply do Hdfs dfs –cat /user/hive/warehouse/hivemb/delta_012_012/bucket_0/* And check the content of file. Thanks Somnath From: unmesha sreeveni [mailto:unmeshab...@gmail.com] Sent: Monday, December 01, 2014 10:31 AM To: User - Hive Subject: How to retriew data f

hive transactions

Hi All, I'm caught up with the error pasted below after trying to use hive transaction feature.I have followed this wiki to set required configuration. https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Configuration set hive.support.concurrency=true; set hive.ex

How to retriew data from a specific bucket in hive?

I created a table in hive create table HiveMB (EmployeeID Int,FirstName String,Designation String,Salary Int,Department String) clustered by (Department) into 3 buckets stored as orc TBLPROPERTIES ('transactional'='true') ; where my file format is like 1,Anne,Admin,5,A 2,Gokul,Admin,50

Re: UPDATE in Hive -0.14.0

Here are some helpful wikidocs: - Hive Transactions - Limitations (file format must be ORC, tables must be

Re: How to provide security in hive using impersonation?

yeah thank you so much Peyman Mohajerian ,is there any other way to make it dynamic? On Sat, Nov 29, 2014 at 7:54 AM, Peyman Mohajerian wrote: > You can use a database, store the users records in there and lookup the > username/password from there using a simple JDBC. > For example you maybe abl