Re: exchange partition documentation

Thanks for the clarification, Navis! On 21 July 2014 14:01, Navis류승우 wrote: > HIVE-4095, originally intended to implement, > > alter table exchange partition () with > table ; > > But in implementation, Dheeraj Kumar Singh, the original implementor, seemed > confused and implemented this in i

Re: Help on restricting users

You can implement that in Hook and register in hive-site.xml. Thanks, Navis 2014-07-19 17:32 GMT+09:00 sai chaitanya tirumerla : > Hi, > > I would like to restrict users doing > "select * from table;" when accessed from any jdbc/odbc tools like sql > workbench/excel etc.. connecting to hiveserv

Re: exchange partition documentation

HIVE-4095, originally intended to implement, alter table exchange partition () with table ; But in implementation, Dheeraj Kumar Singh, the original implementor, seemed confused and implemented this in inverted manner (target to source). HIVE-6129 fixed this(in 0.13.0) and now it's consistent

Re: exchange partition documentation

I'd be happy to update the docs, but need some guidance. The sytax confused me originally -- see comments on HIVE-4095 . I'll add this

Re: exchange partition documentation

Indeed! The documentation is a fair bit off. I've tested the below on Hive 0.12 on CDH and it works fine. Lefty, would you please update the documentation on the two pages below? --- Source: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-

Re: random NPE in HiveInputFormat.init() ??

I thinks it's fixed in https://issues.apache.org/jira/browse/HIVE-7011, which will be included in hive-0.14.0. Sadly, there seemed no simple walkaround for this. Thanks, Navis 2014-07-19 15:03 GMT+09:00 Yang : > > we are getting a random (happening about 20% of the time, if we repeatedly > run

Re: Hive Join Running Out of Memory

Clay, Keep in mind that setting this to false in the global hive-site.xml will mean that you will not do any client hash table generating and will miss out on optimizations for other joins. You should set this in your query directly. Another option is so increase the client side heap to allow fo

exchange partition documentation

I think the documentation related to exchanging partitions is not accurate https://cwiki.apache.org/confluence/display/Hive/Exchange+Partition when I try it out on hortonworks sandbox 2.1 which runs Hive 0.13 I get this: hive> create table T1(a string, b string) partitioned by (ds string); OK