Re: calcite-avatica git commit: [CALCITE-1006] Enable spotbugs-maven-plugin

2018-09-20 Thread Kevin Risden
Sure will do. Kevin Risden On Thu, Sep 20, 2018 at 7:28 PM Julian Hyde wrote: > Can you move spotbugs-filter.xml into src/main/config/spotbugs? The root > directory is expensive real-estate. > > > On Sep 20, 2018, at 2:04 PM, kris...@apache.org wrote: > > > > Repository: calcite-avatica > > Up

Re: calcite-avatica git commit: [CALCITE-1006] Enable spotbugs-maven-plugin

2018-09-20 Thread Julian Hyde
Can you move spotbugs-filter.xml into src/main/config/spotbugs? The root directory is expensive real-estate. > On Sep 20, 2018, at 2:04 PM, kris...@apache.org wrote: > > Repository: calcite-avatica > Updated Branches: > refs/heads/master 6afbfd52a -> 3cfafde9f > > > [CALCITE-1006] Enable spot

Calcite-Master - Build # 853 - Still Failing

2018-09-20 Thread Apache Jenkins Server
The Apache Jenkins build system has built Calcite-Master (build #853) Status: Still Failing Check console output at https://builds.apache.org/job/Calcite-Master/853/ to view the results.

Re: ANALYZE TABLE

2018-09-20 Thread Julian Hyde
Yeah, we should probably go with the de facto standard. But a bigger question is: what would this command do? Calcite has nowhere to store statistics currently. Are people asking for this just so they have a template that they can copy-paste into their own Calcite-based project? Julian > On S

Re: ANALYZE TABLE

2018-09-20 Thread Gautam Parai
Oracle no longer recommends using ANALYZE TABLE except for certain cases and for preserving backwards compatibility. Instead, they now have a DBMS_STATS package with several methods for collecting statistics. [1] ALTER TABLE is usually associated with DDLs. If several projects/vendors already use

Re: ANALYZE TABLE

2018-09-20 Thread Julian Hyde
I can’t believe that Microsoft’s command is “UPDATE STATISTICS”. Especially considering STATISTICS is not an ISO reserved word, so some folks might actually have a table called STATISTICS. In every other database, UPDATE STATISTICS would be a DML command. > On Sep 20, 2018, at 11:07 AM, Julian

Re: ANALYZE TABLE

2018-09-20 Thread Julian Hyde
The Babel parser doesn’t really do DDL (because there is too much variation among dialects). The “server” parser might be a better place for this. It has a few, Calcite-specific DDL statements. It could have ANALYZE too. In my opinion, Oracle made a mistake when they introduced ANALYE TABLE. A

[jira] [Created] (CALCITE-2583) Avatica - Upgrade dropwizard metrics

2018-09-20 Thread Kevin Risden (JIRA)
Kevin Risden created CALCITE-2583: - Summary: Avatica - Upgrade dropwizard metrics Key: CALCITE-2583 URL: https://issues.apache.org/jira/browse/CALCITE-2583 Project: Calcite Issue Type: Improv

Re: [DISCUSS] Towards Calcite 1.18

2018-09-20 Thread Julian Hyde
We’ll be sure to get PRs into the release. If you like, you can make the JIRA case depend on those 3 cases - that will remind us. (Other contributors: You can do that also, but only if you have a PR that you believe is ready to submit.) > On Sep 20, 2018, at 8:18 AM, Andrew Pilloud > wrote: >

[jira] [Created] (CALCITE-2582) FilterProjectTransposeRule does not always simplify the new filter condition

2018-09-20 Thread Stamatis Zampetakis (JIRA)
Stamatis Zampetakis created CALCITE-2582: Summary: FilterProjectTransposeRule does not always simplify the new filter condition Key: CALCITE-2582 URL: https://issues.apache.org/jira/browse/CALCITE-2582

Re: [DISCUSS] Towards Calcite 1.18

2018-09-20 Thread Andrew Pilloud
Beam has a few JIRAs we'd like to see make the next release (which will enable us to replace 11k lines of code with calls to Calcite). They all have open PRs. * https://issues.apache.org/jira/browse/CALCITE-2404 Accessing structured-types is not implemented by the runtime * https://issues.apache.o

ANALYZE TABLE

2018-09-20 Thread Vitalii Diravka
ANALYZE TABLE statement is commonly used by different SQL engines for collecting table statistics: PostgeSQL [1], MySQL [2], ORACLE [3], Microsoft Transact-SQL - UPDATE STATISTICS - [4], SPARK SQL [5], Hive [6]. But I didn't find ANALYZE TABLE statement in SQL specification. Is there any sense to

[jira] [Created] (CALCITE-2581) RexSimplify: and(nullBool, not(or(nullBool, vBool(1)))) fails with assertion error

2018-09-20 Thread Vladimir Sitnikov (JIRA)
Vladimir Sitnikov created CALCITE-2581: -- Summary: RexSimplify: and(nullBool, not(or(nullBool, vBool(1 fails with assertion error Key: CALCITE-2581 URL: https://issues.apache.org/jira/browse/CALCITE-2581

[jira] [Created] (CALCITE-2580) RexSimplify: coalesce(null > null, true) produces wrong result in unknownAsFalse mode

2018-09-20 Thread Vladimir Sitnikov (JIRA)
Vladimir Sitnikov created CALCITE-2580: -- Summary: RexSimplify: coalesce(null > null, true) produces wrong result in unknownAsFalse mode Key: CALCITE-2580 URL: https://issues.apache.org/jira/browse/CALCITE-258

Calcite-Master - Build # 852 - Failure

2018-09-20 Thread Apache Jenkins Server
The Apache Jenkins build system has built Calcite-Master (build #852) Status: Failure Check console output at https://builds.apache.org/job/Calcite-Master/852/ to view the results.

Calcite-Master - Build # 850 - Failure

2018-09-20 Thread Apache Jenkins Server
The Apache Jenkins build system has built Calcite-Master (build #850) Status: Failure Check console output at https://builds.apache.org/job/Calcite-Master/850/ to view the results.