[jira] [Created] (HIVE-20705) Vectorization: Native Vector MapJoin doesn't support Complex Big Table values

[Matt McCline (JIRA)]

Matt McCline created HIVE-20705:
---

 Summary: Vectorization: Native Vector MapJoin doesn't support 
Complex Big Table values
 Key: HIVE-20705
 URL: https://issues.apache.org/jira/browse/HIVE-20705
 Project: Hive
  Issue Type: Bug
  Components: Hive
Reporter: Matt McCline
Assignee: Matt McCline






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (HIVE-20704) Extend HivePreFilteringRule to support other functions

[Jesus Camacho Rodriguez (JIRA)]

Jesus Camacho Rodriguez created HIVE-20704:
--

 Summary: Extend HivePreFilteringRule to support other functions
 Key: HIVE-20704
 URL: https://issues.apache.org/jira/browse/HIVE-20704
 Project: Hive
  Issue Type: Bug
  Components: CBO
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (HIVE-20703) Put dynamic sort partition optimization under cost based decision

[Vineet Garg (JIRA)]

Vineet Garg created HIVE-20703:
--

 Summary: Put dynamic sort partition optimization under cost based 
decision
 Key: HIVE-20703
 URL: https://issues.apache.org/jira/browse/HIVE-20703
 Project: Hive
  Issue Type: Improvement
  Components: Query Planning
Reporter: Vineet Garg
Assignee: Vineet Garg
 Attachments: HIVE-20703.1.patch





--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (HIVE-20702) Account for overhead from datastructure aware estimations during mapjoin selection

[Jesus Camacho Rodriguez (JIRA)]

Jesus Camacho Rodriguez created HIVE-20702:
--

 Summary: Account for overhead from datastructure aware estimations 
during mapjoin selection
 Key: HIVE-20702
 URL: https://issues.apache.org/jira/browse/HIVE-20702
 Project: Hive
  Issue Type: Bug
  Components: Statistics
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (HIVE-20701) Allow HiveStreaming to receive a key value to commit atomically together with the transaction

[Jaume M (JIRA)]

Jaume M created HIVE-20701:
--

 Summary: Allow HiveStreaming to receive a key value to commit 
atomically together with the transaction
 Key: HIVE-20701
 URL: https://issues.apache.org/jira/browse/HIVE-20701
 Project: Hive
  Issue Type: Improvement
Reporter: Jaume M


Following up with https://issues.apache.org/jira/browse/HIVE-20538 it'd be nice 
to be able to use this feature with hive streaming



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (HIVE-20700) Add config to disable rollup for druid

[Nishant Bangarwa (JIRA)]

Nishant Bangarwa created HIVE-20700:
---

 Summary: Add config to disable rollup for druid
 Key: HIVE-20700
 URL: https://issues.apache.org/jira/browse/HIVE-20700
 Project: Hive
  Issue Type: New Feature
  Components: Druid integration
Reporter: Nishant Bangarwa
Assignee: Nishant Bangarwa


Add a table property - 'druid.rollup' to allow disabling rollup for druid 
tables. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (HIVE-20699) Query based compactor for full CRUD Acid tables

[Eugene Koifman (JIRA)]

Eugene Koifman created HIVE-20699:
-

 Summary: Query based compactor for full CRUD Acid tables
 Key: HIVE-20699
 URL: https://issues.apache.org/jira/browse/HIVE-20699
 Project: Hive
  Issue Type: New Feature
  Components: Transactions
Affects Versions: 3.1.0
Reporter: Eugene Koifman
Assignee: Eugene Koifman






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (HIVE-20698) Better error instead of NPE when timestamp is null for any row when ingesting to druid

[Nishant Bangarwa (JIRA)]

Nishant Bangarwa created HIVE-20698:
---

 Summary: Better error instead of NPE when timestamp is null for 
any row when ingesting to druid
 Key: HIVE-20698
 URL: https://issues.apache.org/jira/browse/HIVE-20698
 Project: Hive
  Issue Type: Improvement
  Components: Druid integration
Reporter: Nishant Bangarwa
Assignee: Nishant Bangarwa


Currently when ingesting data to druid we get a wierd NPE when timestamp is 
null for any row. 
We should provide an error with a better message which helps user to know what 
is actually wrong. 

{code} 
Caused by: java.lang.NullPointerException
  at 
org.apache.hadoop.hive.druid.serde.DruidSerDe.serialize(DruidSerDe.java:364)
  at 
org.apache.hadoop.hive.ql.exec.FileSinkOperator.process(FileSinkOperator.java:957)
  at 
org.apache.hadoop.hive.ql.exec.vector.VectorFileSinkOperator.process(VectorFileSinkOperator.java:111)
  at org.apache.hadoop.hive.ql.exec.Operator.vectorForward(Operator.java:965)
  at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:938)
  at 
org.apache.hadoop.hive.ql.exec.vector.VectorSelectOperator.process(VectorSelectOperator.java:158)
  at 
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.processVectorGroup(ReduceRecordSource.java:480)
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (HIVE-20697) Some replication tests are super slow and cause batch timeouts

[Vihang Karajgaonkar (JIRA)]

Vihang Karajgaonkar created HIVE-20697:
--

 Summary: Some replication tests are super slow and cause batch 
timeouts
 Key: HIVE-20697
 URL: https://issues.apache.org/jira/browse/HIVE-20697
 Project: Hive
  Issue Type: Test
Reporter: Vihang Karajgaonkar


Some of these tests are taking a long time and can cause test batch timeouts 
given that we only give 40 min for a batch to complete. We should speed these 
tests up.

TestReplicationScenarios20 min
TestReplicationScenariosAcidTables  11 min
TestReplicationScenariosAcrossInstances 5 min 14 sec
TestReplicationScenariosIncrementalLoadAcidTables   20 min



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Re: Review Request 68868: HIVE-17043: Remove non unique columns from group by keys if not referenced later

[Vineet Garg]

---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/68868/
---

(Updated Oct. 5, 2018, 5:31 p.m.)


Review request for hive and Jesús Camacho Rodríguez.


Bugs: HIVE-17043
https://issues.apache.org/jira/browse/HIVE-17043


Repository: hive-git


Description
---

This patch implements/test the following optimizations
* Removal of group by on primary keys
* Reduction of group by keys on primary keys
* is NOT NULL filter removal if NOT NULL constraint is defined


Diffs (updated)
-

  itests/src/test/resources/testconfiguration.properties d444c99d7b 
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveDefaultRelMetadataProvider.java
 635d27e723 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java 
42e60de6a8 
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveAggregateJoinTransposeRule.java
 f43ef01293 
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRelFieldTrimmer.java
 5857f730a8 
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/EstimateUniqueKeys.java
 PRE-CREATION 
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/HiveRelMdColumnUniqueness.java
 PRE-CREATION 
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/HiveRelMdRowCount.java
 1ca1937ed9 
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/HiveRelMdUniqueKeys.java
 3bf62c535c 
  ql/src/test/queries/clientpositive/constraints_optimization.q PRE-CREATION 
  ql/src/test/results/clientpositive/llap/constraints_optimization.q.out 
PRE-CREATION 
  ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out 
735a4db2ee 


Diff: https://reviews.apache.org/r/68868/diff/4/

Changes: https://reviews.apache.org/r/68868/diff/3-4/


Testing
---


Thanks,

Vineet Garg

Re: Review Request 68895: HadoopVer was ignored in QTestUtil

[Janaki Lahorani via Review Board]

---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/68895/#review209270
---


Ship it!




Ship It!

- Janaki Lahorani


On Oct. 5, 2018, 10 a.m., denys kuzmenko wrote:
> 
> ---
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/68895/
> ---
> 
> (Updated Oct. 5, 2018, 10 a.m.)
> 
> 
> Review request for hive, Zoltan Haindrich and Peter Vary.
> 
> 
> Bugs: HIVE-20647
> https://issues.apache.org/jira/browse/HIVE-20647
> 
> 
> Repository: hive-git
> 
> 
> Description
> ---
> 
> - Removed obsolete hadoopVer from QTestUtil
> 
> - Cleaned up QTestUtil, QTestArgumentsBuilder
> 
> - Refactored AccumuloTestSetup, AccumuloQTestUtil due to findbugs violation:
> (UR_UNINIT_READ_CALLED_FROM_SUPER_CONSTRUCTOR: Uninitialized read of 
> field method called from constructor of superclass)
> 
> 
> Diffs
> -
> 
>   
> itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/TestLocationQueries.java
>  b7e563aebf 
>   itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/TestMTQueries.java 
> 3d8eb83b04 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/accumulo/AccumuloQTestUtil.java
>  060e0cd3e2 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/accumulo/AccumuloTestSetup.java
>  47cf7ac79a 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/cli/control/AbstractCoreBlobstoreCliDriver.java
>  64f29194d5 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreAccumuloCliDriver.java
>  0d64cfa1ac 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreBlobstoreCliDriver.java
>  bdb15b3869 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreBlobstoreNegativeCliDriver.java
>  801c44b40c 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreCliDriver.java
>  841344438e 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreCompareCliDriver.java
>  8ce43495e6 
>   itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreDummy.java 
> 4d40ef9047 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreHBaseCliDriver.java
>  252e9f6b90 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreHBaseNegativeCliDriver.java
>  c009cec57b 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreNegativeCliDriver.java
>  0807da1c7c 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CorePerfCliDriver.java
>  badb4a5888 
>   itests/util/src/main/java/org/apache/hadoop/hive/hbase/HBaseQTestUtil.java 
> 6a6b1003b6 
>   itests/util/src/main/java/org/apache/hadoop/hive/hbase/HBaseTestSetup.java 
> cc63a6cc83 
>   itests/util/src/main/java/org/apache/hadoop/hive/ql/QTestArguments.java 
> 18269ebc92 
>   itests/util/src/main/java/org/apache/hadoop/hive/ql/QTestUtil.java 
> 0e8b82930e 
>   
> itests/util/src/main/java/org/apache/hadoop/hive/ql/parse/CoreParseNegative.java
>  77de3faa1f 
> 
> 
> Diff: https://reviews.apache.org/r/68895/diff/2/
> 
> 
> Testing
> ---
> 
> 
> Thanks,
> 
> denys kuzmenko
> 
>

[jira] [Created] (HIVE-20696) msck_*.q tests are broken

[Jesus Camacho Rodriguez (JIRA)]

Jesus Camacho Rodriguez created HIVE-20696:
--

 Summary: msck_*.q tests are broken
 Key: HIVE-20696
 URL: https://issues.apache.org/jira/browse/HIVE-20696
 Project: Hive
  Issue Type: Bug
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez


Broke by HIVE-19617. Replaced table names but did not replaced folders paths in 
q files.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (HIVE-20695) HoS Query fails with hive.exec.parallel=true

[Yongzhi Chen (JIRA)]

Yongzhi Chen created HIVE-20695:
---

 Summary: HoS Query fails with hive.exec.parallel=true
 Key: HIVE-20695
 URL: https://issues.apache.org/jira/browse/HIVE-20695
 Project: Hive
  Issue Type: Bug
  Components: Spark
Affects Versions: 1.2.1
Reporter: Yongzhi Chen
Assignee: Yongzhi Chen


Hive queries which fail when running a HiveOnSpark job:
{noformat}
ERROR : Failed to execute spark task, with exception 
'java.lang.Exception(Failed to submit Spark work, please retry later)'
java.lang.Exception: Failed to submit Spark work, please retry later
at 
org.apache.hadoop.hive.ql.exec.spark.RemoteHiveSparkClient.execute(RemoteHiveSparkClient.java:186)
at 
org.apache.hadoop.hive.ql.exec.spark.session.SparkSessionImpl.submit(SparkSessionImpl.java:71)
at 
org.apache.hadoop.hive.ql.exec.spark.SparkTask.execute(SparkTask.java:107)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:214)
at 
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:99)
at org.apache.hadoop.hive.ql.exec.TaskRunner.run(TaskRunner.java:79)
Caused by: 
org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.hdfs.server.namenode.LeaseExpiredException):
 No lease on 
/tmp/hive/dbname/_spark_session_dir/e202c452-8793-4e4e-ad55-61e3d4965c69/somename.jar
 (inode 725730760): File does not exist. [Lease.  Holder: 
DFSClient_NONMAPREDUCE_-1981084042_486659, pending creates: 7]
at 
org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkLease(FSNamesystem.java:3755)
at 
org.apache.hadoop.hdfs.server.namenode.FSNamesystem.analyzeFileState(FSNamesystem.java:3556)
at 
org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getAdditionalBlock(FSNamesystem.java:3412)
at 
org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.addBlock(NameNodeRpcServer.java:688)
{format}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (HIVE-20694) Additional unit tests for VectorizedOrcAcidRowBatchReader min max key evaluation

[Saurabh Seth (JIRA)]

Saurabh Seth created HIVE-20694:
---

 Summary: Additional unit tests for VectorizedOrcAcidRowBatchReader 
min max key evaluation
 Key: HIVE-20694
 URL: https://issues.apache.org/jira/browse/HIVE-20694
 Project: Hive
  Issue Type: Test
  Components: Transactions
Reporter: Saurabh Seth


Follow up to HIVE-20664 and HIVE-20635.

Additional unit tests for {{VectorizedOrcAcidRowBatchReader.findMinMaxKeys}} 
and {{VectorizedOrcAcidRowBatchReader.findOriginalMinMaxKeys}} related to split 
and stripe boundaries - particularly the case when a split is completely within 
an ORC stripe.




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Re: Incorrect Release Notes for Hive-2.3.3

[Oleksiy S]

Guys any updates?

On Thu, Oct 4, 2018 at 11:15 AM Oleksiy S 
wrote:

> Current release notes for Hive-2.3.3 are: RNs
> 
>
> Release Notes - Hive - Version 2.3.3
>
> ** Bug
> * [HIVE-16939] - metastore error: 'export: -Dproc_metastore : not a
> valid identifier'
> * [HIVE-18767] - Some alterPartitions invocations throw
> 'NumberFormatException: null'
> * [HIVE-18788] - Clean up inputs in JDBC PreparedStatement
> * [HIVE-18815] - Remove unused feature in HPL/SQL
> * [HIVE-18879] - Disallow embedded element in UDFXPathUtil needs to
> work if xercesImpl.jar in classpath
> * [HIVE-18885] - DbNotificationListener has a deadlock between Java
> and DB locks (2.x line)
> * [HIVE-20304] - When hive.optimize.skewjoin and
> hive.auto.convert.join are both set to true, and the execution engine is
> mr, same stage may launch twice due to the wrong generated plan
> * [HIVE-20441] - NPE in ExprNodeGenericFuncDesc  when
> hive.allow.udf.load.on.demand is set to true
>
> ** Improvement
> * [HIVE-19900] - HiveCLI HoS Performs Invalid Impersonation If User
> Name Truncated
> * [HIVE-20284] - In strict mode, if constant propagation is enable,
> the partition filter may be folded before partition pruner lead to error
> "No partition predicate for Alias"
>
>
> See table for short summary.
> Issue Comment
> HIVE-18767 Issue is not in Hive-2.3.3
> HIVE-20304 Issue is unresolved in Apache Hive JIRA
> HIVE-20441 Issue is unresolved in Apache Hive JIRA
> HIVE-19900 Resolved: Workaround. No commit to see
> HIVE-20284 Issue is unresolved in Apache Hive JIRA
>
> Please remove incorrect JIRAs from RNs.
>
> --
> Oleksiy
>


-- 
Oleksiy

[jira] [Created] (HIVE-20693) Case-sensitivity for column names when reading from ORC

[Alexandre Crayssac (JIRA)]

Alexandre Crayssac created HIVE-20693:
-

 Summary: Case-sensitivity for column names when reading from ORC
 Key: HIVE-20693
 URL: https://issues.apache.org/jira/browse/HIVE-20693
 Project: Hive
  Issue Type: Bug
  Components: Hive, ORC
Affects Versions: 2.3.2
Reporter: Alexandre Crayssac


Hello everyone,

I observed a different behavior between version 1.2.1 and 2.3.2 (that's the 
only two versions I've been able to test).

When creating an external table pointing to ORC files and having upper cased 
column names in the ORC files metadata I'm able to read the data on 1.2.1 but 
not on 2.3.2.

I tested with both upper cased and lower cased column names in my CREATE TABLE 
statement and it does not work in both cases. Looks like normal since column 
names are normalized to lower case in Hive.

So, I would like to know if this is a feature or a bug in Hive 2.3.2 ?

In fact, if this is a feature it would be impossible to have upper case column 
names in ORC files with Hive 2.3.2.

Please, let me know if you need more informations.

Kind regards,

Alexandre



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Re: Review Request 68895: HadoopVer was ignored in QTestUtil

[denys kuzmenko via Review Board]

---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/68895/
---

(Updated Oct. 5, 2018, 10 a.m.)


Review request for hive, Zoltan Haindrich and Peter Vary.


Bugs: HIVE-20647
https://issues.apache.org/jira/browse/HIVE-20647


Repository: hive-git


Description
---

- Removed obsolete hadoopVer from QTestUtil

- Cleaned up QTestUtil, QTestArgumentsBuilder

- Refactored AccumuloTestSetup, AccumuloQTestUtil due to findbugs violation:
(UR_UNINIT_READ_CALLED_FROM_SUPER_CONSTRUCTOR: Uninitialized read of field 
method called from constructor of superclass)


Diffs (updated)
-

  
itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/TestLocationQueries.java
 b7e563aebf 
  itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/TestMTQueries.java 
3d8eb83b04 
  
itests/util/src/main/java/org/apache/hadoop/hive/accumulo/AccumuloQTestUtil.java
 060e0cd3e2 
  
itests/util/src/main/java/org/apache/hadoop/hive/accumulo/AccumuloTestSetup.java
 47cf7ac79a 
  
itests/util/src/main/java/org/apache/hadoop/hive/cli/control/AbstractCoreBlobstoreCliDriver.java
 64f29194d5 
  
itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreAccumuloCliDriver.java
 0d64cfa1ac 
  
itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreBlobstoreCliDriver.java
 bdb15b3869 
  
itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreBlobstoreNegativeCliDriver.java
 801c44b40c 
  
itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreCliDriver.java 
841344438e 
  
itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreCompareCliDriver.java
 8ce43495e6 
  itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreDummy.java 
4d40ef9047 
  
itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreHBaseCliDriver.java
 252e9f6b90 
  
itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreHBaseNegativeCliDriver.java
 c009cec57b 
  
itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CoreNegativeCliDriver.java
 0807da1c7c 
  
itests/util/src/main/java/org/apache/hadoop/hive/cli/control/CorePerfCliDriver.java
 badb4a5888 
  itests/util/src/main/java/org/apache/hadoop/hive/hbase/HBaseQTestUtil.java 
6a6b1003b6 
  itests/util/src/main/java/org/apache/hadoop/hive/hbase/HBaseTestSetup.java 
cc63a6cc83 
  itests/util/src/main/java/org/apache/hadoop/hive/ql/QTestArguments.java 
18269ebc92 
  itests/util/src/main/java/org/apache/hadoop/hive/ql/QTestUtil.java 0e8b82930e 
  
itests/util/src/main/java/org/apache/hadoop/hive/ql/parse/CoreParseNegative.java
 77de3faa1f 


Diff: https://reviews.apache.org/r/68895/diff/2/

Changes: https://reviews.apache.org/r/68895/diff/1-2/


Testing
---


Thanks,

denys kuzmenko

[jira] [Created] (HIVE-20692) IS (NOT) [TRUE|FALSE] logic functions are not folded by Calcite

[Zoltan Haindrich (JIRA)]

Zoltan Haindrich created HIVE-20692:
---

 Summary: IS (NOT) [TRUE|FALSE] logic functions are not folded by 
Calcite
 Key: HIVE-20692
 URL: https://issues.apache.org/jira/browse/HIVE-20692
 Project: Hive
  Issue Type: Improvement
  Components: CBO
Reporter: Zoltan Haindrich
Assignee: Zoltan Haindrich


Expressions like: {{not ((a>0) is not true)}} could be rewritten to {{(a>0) is 
true}}.

However currently this doesn't happen because some of these functions are not 
translated for Calcite.

{code}
create table t (a integer);
explain select not ((a>0) is not true) from t group by a;
[...]
expressions: (not (_col0 > 0) is not true) (type: boolean) |
[...]
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)