Object not found - while querying a type in elastisearch

2017-10-03 Thread AshwinKumar AshwinKumar
Hi Team, I have created a model.json file with two connection instances for postgres and elastisearch . PFB the file - { "version": "1.0", "defaultSchema": "postgrestestelasti", "schemas": [ { "name": "postgrestest", "type": "custom", "factory": "org.apache.calcite.ada

Re: Joining Elastisearch types and Postgres Database tables

2017-10-03 Thread AshwinKumar AshwinKumar
Hi Team, Could you please let me know how to execute sqlline from the root directory. Currently I am running from examples/csv directory which is only for csv. Please let me know how to connect to a jdbc adapter with model.json file. Thanks, Ashwin

Calcite-Master - Build # 115 - Still Failing

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

Re: Joining Elastisearch types and Postgres Database tables

2017-10-03 Thread AshwinKumar AshwinKumar
Hi , I tried running from the root directory. But sqlline gives error saying there is no model.json file when* I do a connect. PFB the output of the command - * *mvn dependency:analyze-only -X* *I executed this command in the directory - * */calcite/example/csv* *[DEBUG

Re: Losing column names when using RelBuilder.values

2017-10-03 Thread Marc Prud'hommeaux
Julian- I managed to reproduce it in isolation. It’s pretty weird. https://issues.apache.org/jira/browse/CALCITE-1996 -Marc > On Oct 2, 2017, at 1:32 PM, Julian Hyde wrote: > > Thanks for investigating. I think you should file a bug report with > everything you know about this issu

[jira] [Created] (CALCITE-1996) Executing RelBuilder.values with a projection sometimes fails

2017-10-03 Thread Marc Prud'hommeaux (JIRA)
Marc Prud'hommeaux created CALCITE-1996: --- Summary: Executing RelBuilder.values with a projection sometimes fails Key: CALCITE-1996 URL: https://issues.apache.org/jira/browse/CALCITE-1996 Project

Re: Joining Elastisearch types and Postgres Database tables

2017-10-03 Thread Michael Mior
Have you tried running sqlline from the root directory of the Calcite repository? I'm not sure the full class path gets picked up by sqlline otherwise. When you tried `mvn install` is that the full error message you got? It looks to be truncated. If running from the root directory doesn't help and

Newbie: Help with VolcanoPlanner query optimization

2017-10-03 Thread Volodymyr Tkach
Hello everyone, I'm new to calcite, and now I'm dealing with issue, when VolcanoPlanner wrongly selects RelNode with the best cost for the current RelSubSet. I make the next query with Apache Drill: *select count(distinct l_linenumber), sum(l_linenumber) from dfs.`/tmp/lineitem.parquet` group b

Re: newbie: DriverManager.getConnection/3 - extending org.apache.calcite.jdbc.Driver

2017-10-03 Thread Alexey Roytman
I did not take the approach of implementing javax.sql.DataSource as this causes implementation of java.sql.Connection and java.sql.Statement; and I want to use Calcite framework for parsing and executing SQL in Statement. So, the code I use now is as following: public class MyDriver extends or

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

2017-10-03 Thread Alexey Roytman
Julian, I don't use the "jdbcUrl", "jdbcUser", "jdbcPassword" per-se, and I cannot define them in the model (in file -- for security reasons; in Properties -- because I cannot change the call type to getConnection). If I need to implement javax.sql.DataSource, I also need to implement javax.sq