Optimizing limit 0 / null scan cases (HIVE-7203)

Hello, We are on hive 1.2.x. We are generating queries of the form (example) CREATE TABLE T . AS WITH T1 AS (SELECT * FROM S1.A), T2 AS (SELECT * FROM S2.B WHERE x > 1000), T3 AS (SELECT * FROM T1 JOIN T2 ON T1.x=T2.y AND T1.z>T2.z) SELECT * from T3

Re: How to pass the TestHplsqlDb test in hive-hplsql?

Bch G Ggg Vghh V Gf G Ck Vjf Fj Fuff Hfg Fhfhhf Ggg Chbg Gh Gjg Jf Gugghhgg Fvgv G Gv G On Aug 1, 2016 1:57 PM, "Dmitry Tolpeko" wrote: > Hi Emerson, > > I did not commit TestHplsqlDb.java since Apache Pre-commit test starts > executing it, and I did not manage how to pass it (the

RE: Getting column statistics on paritioned Hive tables

Thanks. I think using metastore api is what I wanted. Thanks, Bharath From: Mich Talebzadeh [mailto:mich.talebza...@gmail.com] Sent: Thursday, August 18, 2016 2:04 PM To: user Subject: Re: Getting column statistics on paritioned Hive tables In general in Hive 2 you can get statistics for partiti

Re: Getting column statistics on paritioned Hive tables

In general in Hive 2 you can get statistics for partitions by running: hive> analyze table sales partition (year, month) compute statistics; Partition oraclehadoop.sales{year=2000, month=10} stats: [numFiles=256, numRows=21034, totalSize=1651890, rawDataSize=6226064] Partition oraclehadoop.sales{y

Re: Getting column statistics on paritioned Hive tables

> Is there any way to access the column statistics for the whole table? There's no column statistics for the whole table - the only way to get one is to merge all the partition column statistics. The metastore API actually exposes this (if you're looking for schema info to read in a program). ht

Getting column statistics on paritioned Hive tables

Hi, I was trying to get column statistics for a partitioned hive table. Generally for a non-partitioned table I can run `ANALYZE TABLE TABLENAME COMPUTE STATISTICS FOR COLUMNS` and I can access the column statistics by `DESCRIBE FORMATTED TABLENAME COLUMNNAME` from the hive client. This does

why need set hive.server2.enable.doAs=false in SQL-Standard Based Authorization

Hi,all:   I have a few questions about hive authentication and authorization: (1)why do we need to set hive.server2.enable.doAs=false in SQL-Standard Based Authorization ? (2)when set hive.server2.enable.doAs=false in SQL-Standard Based Authorization,the beeline way to connecte HS2,  the queri

Re: Hive logging 2.0.0

copy $HIVE_HOME/conf/hive-log4j2.properties.template to $HIVE_HOME/conf/hive-log4j2.properties Change the values in that file to WARN etc. For example property.hive.log.level = INFO HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOAB