RE: More than one table created at the same location

2016-08-31 Thread Santlal J Gupta
hi, I also found that more than one table can be created by pointing to same location. But @Naveen i had found some different behavior in case of count(*). Below thing i have tried . hive> create table test1(f1 int,f2 int) stored as orc location '/user/xyz/warehouse/test1' ; hive> insert

Review Request 51568: HIVE-13555 add nullif

2016-08-31 Thread Zoltan Haindrich
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51568/ --- Review request for hive and Ashutosh Chauhan. Bugs: HIVE-13555

Re: Review Request 51397: HIVE-14536 Unit test code cleanup

2016-08-31 Thread Peter Vary
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51397/ --- (Updated Aug. 31, 2016, 11:58 p.m.) Review request for hive, Ashutosh Chauhan,

Re: Review Request 51312: HIVE-14589 add consistent node replacement to LLAP for splits

2016-08-31 Thread Sergey Shelukhin
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51312/#review147499 ---

Re: Review Request 51312: HIVE-14589 add consistent node replacement to LLAP for splits

2016-08-31 Thread Sergey Shelukhin
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51312/ --- (Updated Aug. 31, 2016, 10:25 p.m.) Review request for hive and Prasanth_J.

Re: Review Request 51312: HIVE-14589 add consistent node replacement to LLAP for splits

2016-08-31 Thread Sergey Shelukhin
> On Aug. 30, 2016, 10:35 p.m., Siddharth Seth wrote: > > ql/src/test/org/apache/hadoop/hive/ql/exec/tez/TestHostAffinitySplitLocationProvider.java, > > line 98 > > > > > > This isn't part of the patch uploaded to

Re: Review Request 51312: HIVE-14589 add consistent node replacement to LLAP for splits

2016-08-31 Thread Sergey Shelukhin
> On Aug. 30, 2016, 10:36 p.m., Siddharth Seth wrote: > > Unrelated to this patch - Any idea why 'uniq' is static/ (private static > > final UUID uniq = UUID.randomUUID();) it's daemon identity, so it's global per daemon - Sergey ---

Re: Review Request 51312: HIVE-14589 add consistent node replacement to LLAP for splits

2016-08-31 Thread Sergey Shelukhin
> On Aug. 30, 2016, 10:35 p.m., Siddharth Seth wrote: > > llap-client/src/java/org/apache/hadoop/hive/llap/registry/impl/LlapZookeeperRegistryImpl.java, > > line 104 > > > > > > Move this into a separate path

[jira] [Created] (HIVE-14683) ptest uses invalid killall command

2016-08-31 Thread Siddharth Seth (JIRA)
Siddharth Seth created HIVE-14683: - Summary: ptest uses invalid killall command Key: HIVE-14683 URL: https://issues.apache.org/jira/browse/HIVE-14683 Project: Hive Issue Type: Sub-task

[jira] [Created] (HIVE-14682) Fix errors during cleanup when executing certain q files

2016-08-31 Thread Siddharth Seth (JIRA)
Siddharth Seth created HIVE-14682: - Summary: Fix errors during cleanup when executing certain q files Key: HIVE-14682 URL: https://issues.apache.org/jira/browse/HIVE-14682 Project: Hive

[jira] [Created] (HIVE-14681) Remove AssertionError for non zero return codes in QTestUtil cleanup

2016-08-31 Thread Siddharth Seth (JIRA)
Siddharth Seth created HIVE-14681: - Summary: Remove AssertionError for non zero return codes in QTestUtil cleanup Key: HIVE-14681 URL: https://issues.apache.org/jira/browse/HIVE-14681 Project: Hive

[jira] [Created] (HIVE-14680) retain consistent splits /during/ (as opposed to across) LLAP failures on top of HIVE-14589

2016-08-31 Thread Sergey Shelukhin (JIRA)
Sergey Shelukhin created HIVE-14680: --- Summary: retain consistent splits /during/ (as opposed to across) LLAP failures on top of HIVE-14589 Key: HIVE-14680 URL: https://issues.apache.org/jira/browse/HIVE-14680

Re: Review Request 51542: HIVE-14652 incorrect results for not in on partition columns

2016-08-31 Thread Jesús Camacho Rodríguez
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51542/#review147482 --- Ship it! Ship It! - Jesús Camacho Rodríguez On Aug. 31,

Re: Review Request 51542: HIVE-14652 incorrect results for not in on partition columns

2016-08-31 Thread Jesús Camacho Rodríguez
> On Aug. 31, 2016, 6:31 p.m., Jesús Camacho Rodríguez wrote: > > ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/PcrExprProcFactory.java, > > line 286 > > > > > > Will STRUCT with all constants inside e.g. (x,

Re: Review Request 51542: HIVE-14652 incorrect results for not in on partition columns

2016-08-31 Thread Sergey Shelukhin
> On Aug. 31, 2016, 6:31 p.m., Jesús Camacho Rodríguez wrote: > > ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/PcrExprProcFactory.java, > > line 286 > > > > > > Will STRUCT with all constants inside e.g. (x,

Re: Review Request 51542: HIVE-14652 incorrect results for not in on partition columns

2016-08-31 Thread Sergey Shelukhin
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51542/ --- (Updated Aug. 31, 2016, 7:38 p.m.) Review request for hive and Jesús Camacho

Re: Review Request 51542: HIVE-14652 incorrect results for not in on partition columns

2016-08-31 Thread Jesús Camacho Rodríguez
> On Aug. 31, 2016, 6:31 p.m., Jesús Camacho Rodríguez wrote: > > ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/PcrExprProcFactory.java, > > line 375 > > > > > > WalkState.CONSTANT or WalkState.UNKNOWN? (I

Re: Review Request 51542: HIVE-14652 incorrect results for not in on partition columns

2016-08-31 Thread Sergey Shelukhin
> On Aug. 31, 2016, 6:31 p.m., Jesús Camacho Rodríguez wrote: > > ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/PcrExprProcFactory.java, > > line 286 > > > > > > Will STRUCT with all constants inside e.g. (x,

Re: Review Request 51542: HIVE-14652 incorrect results for not in on partition columns

2016-08-31 Thread Sergey Shelukhin
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51542/ --- (Updated Aug. 31, 2016, 6:42 p.m.) Review request for hive and Jesús Camacho

Re: Review Request 51542: HIVE-14652 incorrect results for not in on partition columns

2016-08-31 Thread Jesús Camacho Rodríguez
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51542/#review147456 ---

Re: Review Request 51435: HIVE-14426 Extensive logging on info level in WebHCat

2016-08-31 Thread Chaoyu Tang
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51435/#review147447 --- Ship it! LGTM - Chaoyu Tang On Aug. 31, 2016, 3:32 p.m.,

Re: Review Request 51435: HIVE-14426 Extensive logging on info level in WebHCat

2016-08-31 Thread Peter Vary
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51435/ --- (Updated Aug. 31, 2016, 3:32 p.m.) Review request for hive, Chaoyu Tang, Gabor

Re: Review Request 51435: HIVE-14426 Extensive logging on info level in WebHCat

2016-08-31 Thread Peter Vary
> On Aug. 27, 2016, 3:20 a.m., Chaoyu Tang wrote: > > common/src/java/org/apache/hadoop/hive/conf/HiveConfUtil.java, line 72 > > > > > > hive.conf.hidden.list is usually not default specified in > > configurations

[jira] [Created] (HIVE-14679) csv2/tsv2 output format disables quoting by default and it's extremely difficult to enable

2016-08-31 Thread Brock Noland (JIRA)
Brock Noland created HIVE-14679: --- Summary: csv2/tsv2 output format disables quoting by default and it's extremely difficult to enable Key: HIVE-14679 URL: https://issues.apache.org/jira/browse/HIVE-14679

Re: Review Request 51435: HIVE-14426 Extensive logging on info level in WebHCat

2016-08-31 Thread Peter Vary
> On Aug. 31, 2016, 1:48 a.m., Chaoyu Tang wrote: > > hcatalog/webhcat/svr/src/main/java/org/apache/hive/hcatalog/templeton/tool/TempletonUtils.java, > > line 488 > > > > > > I missed this in last review. > >

Re: Review Request 51435: HIVE-14426 Extensive logging on info level in WebHCat

2016-08-31 Thread Peter Vary
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/51435/ --- (Updated Aug. 31, 2016, 3:06 p.m.) Review request for hive, Chaoyu Tang, Gabor

Re: Review Request 51435: HIVE-14426 Extensive logging on info level in WebHCat

2016-08-31 Thread Peter Vary
> On Aug. 27, 2016, 3:20 a.m., Chaoyu Tang wrote: > > common/src/java/org/apache/hadoop/hive/conf/HiveConfUtil.java, line 72 > > > > > > hive.conf.hidden.list is usually not default specified in > > configurations

Re: Why beeline use BufferedRows by default instead of IncrementalRows ?

2016-08-31 Thread Sergio Pena
Hi, There is a JIRA that was just fixed that sets incremental rows as default. https://issues.apache.org/jira/browse/HIVE-14170 You should see this change on the next release Hive 2.2 On Wed, Aug 31, 2016 at 9:39 AM, xiaoyuan wrote: > Hi, > > When I use beeline to execute a

[jira] [Created] (HIVE-14678) Hive-on-MR deprecation warning is not diplayed when engine is set to capital letter 'MR'

2016-08-31 Thread Raja Mannem (JIRA)
Raja Mannem created HIVE-14678: -- Summary: Hive-on-MR deprecation warning is not diplayed when engine is set to capital letter 'MR' Key: HIVE-14678 URL: https://issues.apache.org/jira/browse/HIVE-14678

Beeline history problem

2016-08-31 Thread xiaoyuan
Hi All, I am using beeline on my local machine, when I press the up key, it does not show the last command but something like “^[[A”, and when I press the down key, “^[[B” is showing. I am not sure whether this is a bug or I miss some configurations ? Thanks~

Re: More than one table created at the same location

2016-08-31 Thread naveen mahadevuni
Hi, I created external table, copied data files to that location and then count returns 4. It is ambiguous, can it be documented? hive> CREATE EXTERNAL TABLE test_ext (col1 INT, col2 INT) > stored as orc > LOCATION '/apps/hive/warehouse/ext'; OK Time taken: 9.875 seconds hive> select

Re: Review Request 51435: HIVE-14426 Extensive logging on info level in WebHCat

2016-08-31 Thread Chaoyu Tang
> On Aug. 31, 2016, 1:48 a.m., Chaoyu Tang wrote: > > hcatalog/webhcat/svr/src/main/java/org/apache/hive/hcatalog/templeton/tool/TempletonUtils.java, > > line 488 > > > > > > I missed this in last review. > >

Re: Review Request 51435: HIVE-14426 Extensive logging on info level in WebHCat

2016-08-31 Thread Chaoyu Tang
> On Aug. 27, 2016, 3:20 a.m., Chaoyu Tang wrote: > > common/src/java/org/apache/hadoop/hive/conf/HiveConfUtil.java, line 72 > > > > > > hive.conf.hidden.list is usually not default specified in > > configurations

[jira] [Created] (HIVE-14677) Beeline should support executing an initial SQL script

2016-08-31 Thread Ferdinand Xu (JIRA)
Ferdinand Xu created HIVE-14677: --- Summary: Beeline should support executing an initial SQL script Key: HIVE-14677 URL: https://issues.apache.org/jira/browse/HIVE-14677 Project: Hive Issue

[jira] [Created] (HIVE-14676) JDBC driver should support executing an initial SQL script

2016-08-31 Thread Ferdinand Xu (JIRA)
Ferdinand Xu created HIVE-14676: --- Summary: JDBC driver should support executing an initial SQL script Key: HIVE-14676 URL: https://issues.apache.org/jira/browse/HIVE-14676 Project: Hive Issue