How to get AvaticaParameter when PreparedStatement used?

Dear guys, in my case, how can I get the real value of "?0" and "?1" ? String strsql = "select * from t1 where c1 = ? and c2 =?"; ps = pconn.prepareStatement(strsql); ps.setString(1,"1"); ps.setLong(2,2);

Re: count(distinct col) can't recognize distinct

Can you give a specific example of a query that doesn't do what you expect it to do? -- Michael Mior mm...@apache.org Le mar. 13 nov. 2018 à 07:56, 大明 a écrit : > Hi Guys: > > > I got a question why it can't recognize DISTINCT tag on COUNT(DISTINCT > col) aggregation function sometimes. > > >

count(distinct col) can't recognize distinct

Hi Guys: I got a question why it can't recognize DISTINCT tag on COUNT(DISTINCT col) aggregation function sometimes. but it is not problem when my sql query statement have WHEN clause or one more aggregation functions. Best Regards Haochao Zhuang

[jira] [Created] (CALCITE-2667) sql2rel fails on join between table function and other table

Piotr Bojko created CALCITE-2667: Summary: sql2rel fails on join between table function and other table Key: CALCITE-2667 URL: https://issues.apache.org/jira/browse/CALCITE-2667 Project: Calcite

[jira] [Created] (CALCITE-2668) Support for left/right outer join in RelMdExpressionLineage

Jesus Camacho Rodriguez created CALCITE-2668: Summary: Support for left/right outer join in RelMdExpressionLineage Key: CALCITE-2668 URL: https://issues.apache.org/jira/browse/CALCITE-2668

Calcite-Master - Build # 963 - Still Failing

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

Re: [DISCUSS] Towards Avatica 1.13.0

I checked my PRs and they can't be merged yet for various reasons. CALCITE-2322 would be good to get in. CALCITE-2412 I think is pretty close just needs to be updated to current master. I checked on Travis CI a few weeks ago for Windows support and it didn't look like it had everything yet. I

Calcite-Master - Build # 962 - Still Failing

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

?????? count(distinct col) can't recognize distinct

Dears i catch it in the solr adaptor. it is implemented by solr as elasticsearch adaptor. case a: correct select a, count(distinct b) from tbl group by a; case b: incorrect 1. select a, count(distinct b) from tbl where c = 'c' group by a; 2. select a, count(distinct b), max(c) from tbl

Calcite-Master - Build # 966 - Still Failing

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

[jira] [Created] (CALCITE-2669) RelMdTableReferences should check whether references inferred from input are null for Union/Join operators

Jesus Camacho Rodriguez created CALCITE-2669: Summary: RelMdTableReferences should check whether references inferred from input are null for Union/Join operators Key: CALCITE-2669 URL:

?????? count(distinct col) can't recognize distinct

Hi Julian, yes, it occurs in solr-adapter. we need to get the DISTINCT status for translating to solr's query plan. So can I skip this optimization? If I can't, I will make a JIRA case. Thanks, Haochao Zhuang -- -- ??: "Julian Hyde";

Re: 回复： count(distinct col) can't recognize distinct

The plan is correct for the following query: select channel, count(distinct version) from daming group by channel 76:SolrAggregate(group=[{0}], EXPR$1=[COUNT($1)]) 74:SolrAggregate(group=[{4, 7}]) 0:SolrTableScan(table=[[test03.loc:2181/dmsolr, daming]]) It will first get group by channel

Unable to build avatica: Version for 'Apache Calcite Avatica Dropwizard Metrics' was not mapped

I am trying to build an avatica release with the -DdryRun flag: mvn -DdryRun=true -DreleaseVersion=1.13.0 -DdevelopmentVersion=1.14.0-SNAPSHOT -Dtag="avatica-1.13.0-rc0" -Papache-release -Duser.name=francischuang release:prepare I am building in the latest maven docker image (Ubuntu 18.04

Re: count(distinct col) can't recognize distinct

Can you log a JIRA case? This is specific to the Solr adapter, yes? If so, make that clear in the JIRA case. Julian > On Nov 13, 2018, at 7:29 PM, Haisheng Yuan wrote: > > The plan is correct for the following query: > > select channel, count(distinct version) from daming group by channel >

?????? count(distinct col) can't recognize distinct

Maybe I need to show more detail about this. I printed the explaination using `input.explain(pw)`. select channel, count(distinct version), sum(amount) from daming group by channel 500:SolrAggregate(group=[{4}], EXPR$1=[COUNT(DISTINCT $7)], EXPR$2=[SUM($0)])

Re: Unable to build avatica: Version for 'Apache Calcite Avatica Dropwizard Metrics' was not mapped

I was able to fix by doing a `git reset --hard` and `git clean -fxd`. I think a previous failed build created some unwanted files in the working tree. On 14/11/2018 4:41 pm, Francis Chuang wrote: I am trying to build an avatica release with the -DdryRun flag: mvn -DdryRun=true

?????? Re: ?????? count(distinct col) can't recognize distinct

Oh, I get it. Thank you very much. Haochao Zhuang -- -- ??: "Haisheng Yuan"; : 2018??11??14??(??) 11:29 ??: "";"dev"; : Re: ?? count(distinct col) can't recognize distinct The plan is correct for the

Re: Potential student projects

Thanks Francis! Bug fixing and more mechanical work like adding new types is probably out of scope for the kinds of projects I'm looking for. Ideally these would be projects with a fairly significant amount of design work. The client-driven load balancing piece has some potential :) -- Michael

Calcite-Master - Build # 965 - Still Failing

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

Re: Potential student projects

There’s always more work to be done in Geospatial, e.g. https://issues.apache.org/jira/browse/CALCITE-2031 . The easy part is to create scalar (row-at-a-time) implementations of spatial functions, but the real fun starts when you transform

Re: [DISCUSS] Towards Avatica 1.13.0

Thanks for taking a look, Kevin! I'll try and see if I can get in touch with the Sergey and Kevin Minder to see if those PRs can make it into this release. Francis On 14/11/2018 2:15 am, Kevin Risden wrote: I checked my PRs and they can't be merged yet for various reasons. CALCITE-2322

Re: Potential student projects

Good thought. I'll keep that in mind as well. There's probably far more projects (and students) than I'll be able to supervise, but hopefully Calcite will be able to get some mileage from this. -- Michael Mior mm...@apache.org Le mar. 13 nov. 2018 à 13:04, Julian Hyde a écrit : > There’s

Re: Potential student projects

I think it’s important that the project should start off with some “mechanical” stuff that doesn’t require any design. Coming up to speed on a new code base is challenging. The GIS functions work has that property. > On Nov 13, 2018, at 11:36 AM, Michael Mior wrote: > > Good thought. I'll

Calcite-Master - Build # 964 - Still Failing

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

Re: Potential student projects

Agreed. Students only have a few months to take this project from start to finish so anything which helps them get up to speed is a plus. -- Michael Mior mm...@apache.org Le mar. 13 nov. 2018 à 14:39, Julian Hyde a écrit : > I think it’s important that the project should start off with some >

Re: Potential student projects

For Avatica, there are a few issues open for better integration with HSQLDB (support for more types and some bugs): - CALCITE-1951: https://issues.apache.org/jira/browse/CALCITE-1951 - CALCITE-2250: https://issues.apache.org/jira/browse/CALCITE-1950 - CALCITE-1957: