Re: RexCall Data Type

You probably wouldn’t want Calcite to promote every int * int operation to a higher type; otherwise int_column * int_column * int_column would need a 96 bit (or larger) integer type. The simplest thing is cast one or both or the input values to the larger type, and the result will be that

RexCall Data Type

Hi All, Please consider the following SQL: select INT_COLUMN * INT_COLUMN from SOME_TABLE; The data type of the INT_COLUMN * INT_COLUMN expression is still an INTEGER provided that the INT_COLUMN type is INTEGER as well. This could lead to a potential overflow if the column value is big enough.

Re: Joining Elastisearch types and Postgres Database tables

Sorry, I have no idea. > On Oct 2, 2017, at 5:26 PM, AshwinKumar AshwinKumar > wrote: > > Hi Julian, > > I tried that too. But it happens to give the same error. Actually I am > executing from the folder */calcite/example/csv. *I also changed the > pom.xml file to add

Re: Joining Elastisearch types and Postgres Database tables

Hi Julian, I tried that too. But it happens to give the same error. Actually I am executing from the folder */calcite/example/csv. *I also changed the pom.xml file to add the postgresql dependency and executed the command - !connect jdbc:calcite:model=target/test-classes/model.json admin admin

Re: newbie: DriverManager.getConnection(url, user, password) and "lost" credentials in SchemaFactory's Map

Rather than connecting to JDBC using “jdbcUrl", “jdbcUser", “jdbcPassword” operands of the JDBC adapter you could instead connect to a data source. Write a class that implements javax.sql.DataSource, and include the class name in the model with a “dataSource” operand. Your class can

Re: Joining Elastisearch types and Postgres Database tables

Looks good, except that I’d change > "defaultSchema": "SALES Samplepostgres”, to > "defaultSchema": "SALES”, Julian > On Oct 2, 2017, at 2:38 PM, AshwinKumar AshwinKumar > wrote: > > Sorry this is the proper json file - > > { > "version": "1.0", >

Re: Joining Elastisearch types and Postgres Database tables

Sorry this is the proper json file - { "version": "1.0", "defaultSchema": "SALES Samplepostgres", "schemas": [ { "name": "SALES", "type": "custom", "factory": "org.apache.calcite.adapter.csv.CsvSchemaFactory", "operand": { "directory": "sales" }

Calcite-Master - Build # 114 - Still Failing

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

Re: Joining Elastisearch types and Postgres Database tables

Easiest thing is to create a JSON model file with two schemas in it. https://calcite.apache.org/docs/model.html https://calcite.apache.org/docs/adapter.html > On Oct 2, 2017, at 11:48 AM, AshwinKumar

Re: Joining Elastisearch types and Postgres Database tables

Could you please give me some pointers for where can I get some documentation or links on how to connect elastisearch and postgres in same query. As we know Elastisearch has a separate adapter and postgres comes under jdbc adapter. Do we need to create a root schema using jdbc adapter for

Re: [VOTE] Release apache-calcite-1.14.0 (release candidate 0)

Thanks Michael. Other committers, please give me a couple of hours to complete test runs on my changes and commit them. After you see my commits go in later this afternoon, have at it. Julian > On Oct 2, 2017, at 11:34 AM, Michael Mior wrote: > > I merged the release

Re: Joining Elastisearch types and Postgres Database tables

Yes, you should be able to combine any data source with any other data source in a query. Julian > On Oct 2, 2017, at 11:40 AM, AshwinKumar AshwinKumar > wrote: > > Hello Team, > > I had a question regarding connecting Elastisearch and Postgres Database in > a single

Joining Elastisearch types and Postgres Database tables

Hello Team, I had a question regarding connecting Elastisearch and Postgres Database in a single query. Could you please let me know If we can query a elastisearch type(table) and a postgres table in the same query. Thanks, Ashwin

Re: [VOTE] Release apache-calcite-1.14.0 (release candidate 0)

I merged the release branch and everything looks good to go. Push away! -- Michael Mior mm...@apache.org 2017-10-02 14:06 GMT-04:00 Julian Hyde : > Please let us know when master is again open for commits. I have built up > a large stack of commits that I would like to start

Re: [VOTE] Release apache-calcite-1.14.0 (release candidate 0)

Please let us know when master is again open for commits. I have built up a large stack of commits that I would like to start pushing. > On Oct 2, 2017, at 7:42 AM, Michael Mior wrote: > > Thanks. Pushed the release and I'm just merging back to master and writing > release

Calcite-Master - Build # 113 - Still Failing

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

Calcite-Master - Build # 112 - Still Failing

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

Re: Losing column names when using RelBuilder.values

Thanks for investigating. I think you should file a bug report with everything you know about this issue. It passes my threshold of “undesirable behavior”. If we later get a reproducible test case and a fix that’s a bonus. > On Oct 2, 2017, at 7:58 AM, Marc Prud'hommeaux

Re: Does calcite have working ElasticSearch 5 adapter?

It would be great if there was a brief description in https://calcite.apache.org/docs/elasticsearch_adapter.html that lists what does and does not work. Kant, If you find out what the adapter does, consider making a pull request to

Re: API docs update clarification

Disregard. I see this is covered in the site documentation. I'll update the release documentation to make this more clear. -- Michael Mior mm...@apache.org 2017-10-02 11:00 GMT-04:00 Michael Mior : > The process for updating the API documentation is a little unclear. >

Re: Assunto: Re: To get started with Postgres and SqlServer

Thanks Luis, That worked. I created the table with column names inuppercase. On Sun, Oct 1, 2017 at 6:38 PM, Luis Fernando Kauer wrote: > Hi. > > Have you tried a simple query that selects the empno column from table3? > Calcite converts column names to uppercase and it

API docs update clarification

The process for updating the API documentation is a little unclear. Firstly, I'm assuming I should be building documentation from the release tag and not the new snapshot version. Second, the HOWTO currently just says where I should copy the documentation *to*, but not where it should be copied

Re: Losing column names when using RelBuilder.values

Interestingly, it turns out this only happens when I re-use a RelBuilder than I’ve used for a bunch of other operations, even though I call clear() on it. When I use a fresh new RelBuilder, I’m able to select from a multi-values values call. I’ll look into it some more and file a bug report

Re: [VOTE] Release apache-calcite-1.14.0 (release candidate 0)

Thanks. Pushed the release and I'm just merging back to master and writing release notes now so we should be good to unfreeze master soon. -- Michael Mior mm...@apache.org 2017-10-02 10:20 GMT-04:00 Julian Hyde : > You can close the vote, because we have 3 vote majority

[RESULT] [VOTE] Release apache-calcite-1.14.0 (release candidate 0)

Thanks to everyone who has tested the release candidate and given their comments and votes. The tally is as follows. 3 binding +1s: Michael Julian Aman 1 non-binding +1: Gian No 0s or -1s. Therefore I am delighted to announce that the proposal to release Apache Calcite 1.14.0 has passed.

Re: [VOTE] Release apache-calcite-1.14.0 (release candidate 0)

You can close the vote, because we have 3 vote majority and >72 hours. Send the result email. Push the bits. Wait 24 hours then announce. Julian Ps thanks to all who voted! > On Oct 2, 2017, at 07:00, Michael Mior wrote: > > Thanks Aman! That makes three binding +1s. If

Re: FW: [VOTE] Release apache-calcite-1.14.0 (release candidate 0)

Thanks Aman! That makes three binding +1s. If I understand the release process correctly, I'm good to go ahead and perform the release today. -- Michael Mior mm...@apache.org 2017-10-01 23:44 GMT-04:00 Aman Sinha : > I just downloaded the src and built on my Linux VM with

Re: Does calcite have working ElasticSearch 5 adapter?

You can see what is supported by looking at the tests for the adapter. Mit freundlichen Grüßen, *Christian Beikov* Am 02.10.2017 um 10:17 schrieb kant kodali: where can I find all the operations the current ES5 adapter

Re: Does calcite have working ElasticSearch 5 adapter?

where can I find all the operations the current ES5 adapter can support? any ES5 examples? I have to deep dive into code before I can commit towards contribution but I can see what I will be able to do. On Mon, Oct 2, 2017 at 12:52 AM, Christian Beikov < christian.bei...@gmail.com> wrote: > It