Re: An exception after rewriting a casting expression to a scalar subquery

2019-03-07 Thread Muhammad Gelbana
Actually the types is derived this way final RelDataType type = typeFactory.createTypeWithNullability(fieldList.get(0).getType(), *true*); Reference: https://github.com/apache/calcite/blob/d10aeb7f7e50dc7028ce102a5f590d0c50c49fa8/core/src/main/java/org/apache/calcite/rex/RexSubQuery.java#L99 If

Re: An exception after rewriting a casting expression to a scalar subquery

2019-03-07 Thread Stamatis Zampetakis
Sorry, I meant to write instead of final RelDataType type = typeFactory.createTypeWithNullability(fieldList.get(0).getType(), true); in my previous email. I think it would make sense to change the hardcoded value but I didn't try to see if there are test failures after the change neither I know

Re: An exception after rewriting a casting expression to a scalar subquery

2019-03-07 Thread Muhammad Gelbana
https://issues.apache.org/jira/browse/CALCITE-2901 Thanks, Gelbana On Thu, Mar 7, 2019 at 11:33 AM Stamatis Zampetakis wrote: > Sorry, I meant to write instead of > > final RelDataType type = > typeFactory.createTypeWithNullability(fieldList.get(0).getType(), true); > > in my previous email. >

[jira] [Created] (CALCITE-2901) RexSubQuery.scalar needs to allow specifying a different nullability value instead of the hard coded "true" value

2019-03-07 Thread Muhammad Gelbana (JIRA)
Muhammad Gelbana created CALCITE-2901: - Summary: RexSubQuery.scalar needs to allow specifying a different nullability value instead of the hard coded "true" value Key: CALCITE-2901 URL: https://issues.apache.o

JIRA Permissions to create 1.20.0 version?

2019-03-07 Thread Kevin Risden
I was looking to move 1.19.0 issues that aren't ready to 1.20.0, but don't have permissions in the CALCITE JIRA project to create a new version. Can this permission be provided? Kevin Risden

Re: JIRA Permissions to create 1.20.0 version?

2019-03-07 Thread Michael Mior
Strange. You're already an admin so you should have permissions. In any case, I created the new release. -- Michael Mior mm...@apache.org Le jeu. 7 mars 2019 à 08:47, Kevin Risden a écrit : > > I was looking to move 1.19.0 issues that aren't ready to 1.20.0, but don't > have permissions in the CA

Re: JIRA Permissions to create 1.20.0 version?

2019-03-07 Thread Kevin Risden
Hmmm looks it was user error. I clicked around and saw the greyed out Add button. Looks like need to fill in the top field before button becomes available. Sorry. Thanks for creating the new verison. Kevin Risden On Thu, Mar 7, 2019 at 9:06 AM Michael Mior wrote: > Strange. You're already an a

Calcite-Master - Build # 1065 - Still Failing

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

Re: Calcite-RelNode clarifications

2019-03-07 Thread Chris Baynes
1. Could you give an example of what your expected output/query is here? I'm not sure what you're trying to achieve. 2. There are mappings in MysqlSqlDialect.java from Calcite FLOOR to Mysql DATE_FORMAT. So what you want in your RelNode is something like FLOOR(HIRE_DATE TO day) On Tue, Mar 5, 2019

using calcite to read csv files from hdfs.

2019-03-07 Thread 勾王敏浩
Hello, everyone. This is Wangminhao Gou. I have an urgent need now. I want to read CSV files from remote HDFS and parse them using calcite. Now that I can use a file stream to get this CSV file, and understand how to use calcite to make a relational table of the local csv, what should I do next

Re: using calcite to read csv files from hdfs.

2019-03-07 Thread Andrei Sereda
Hi Gou, CsvSchema uses java.io.File API to scan a directory and doesn't speak HDFS directly (nor does it accept generic java.io.Reader to construct it). Is there a way for you to mount HDFS using FUSE ? Example MountableHDFS . Regards, Andrei. On T

Re: using calcite to read csv files from hdfs.

2019-03-07 Thread Albert
I would say calcite csv example is a good start point. On Fri, Mar 8, 2019 at 10:10 AM 勾王敏浩 wrote: > Hello, everyone. > This is Wangminhao Gou. I have an urgent need now. I want to read CSV > files from remote HDFS and parse them using calcite. Now that I can use a > file stream to get this CSV