Re: User defined functions

[Stamatis Zampetakis]

Hello Subbarao,

I am not sure, I understand what you want to achieve.

I suppose you are using the JdbcSchema (directly or indirectly), most
likely through the JDBC Adapter.
If that's the case then probably the reason that you don't see the
user-defined functions is that the getFunctions() method is not yet
implemented.

Best,
Stamatis

2018-07-12 7:12 GMT+02:00 subbarao mitta :

> Hi how to add existing user defined functions in Oracle database to schema
> in calcite.I am connected Oracle database using schema but I don't know how
> to add existing user defined functions to schema.
>

Several pages at calcite.apache.org are unavailable

[Sergey Nuyanzin]

Hello everyone

Just faced several issues with the site cacite.apache.org
there are some links are unavailable from the main page (I checked only
from the main)

here it is the list of broken pages
-- Release 1.17.0 (At the same time the page is available at
http://calcite.apache.org/docs/history.html#v1-17-0)
-- Calcite adds 5 committers
-- Algebra builder
-- Calcite adds 2 committers
-- 1.17.0

-- 
Best regards,
Sergey

Re: Several pages at calcite.apache.org are unavailable

[Michael Mior]

Thanks for pointing this out Sergey! It looks like at least some of
those are due to a build which misinterpreted the time zone in the
article timestamp causing a URL to be generated with the wrong date.
I'm taking a look now.

--
Michael Mior
mm...@apache.org
Le ven. 20 juil. 2018 à 12:03, Sergey Nuyanzin  a écrit :
>
> Hello everyone
>
> Just faced several issues with the site cacite.apache.org
> there are some links are unavailable from the main page (I checked only
> from the main)
>
> here it is the list of broken pages
> -- Release 1.17.0 (At the same time the page is available at
> http://calcite.apache.org/docs/history.html#v1-17-0)
> -- Calcite adds 5 committers
> -- Algebra builder
> -- Calcite adds 2 committers
> -- 1.17.0
>
> --
> Best regards,
> Sergey

Re: Several pages at calcite.apache.org are unavailable

[Michael Mior]

It looks like this builds correctly on my machine. Now that the
release is out, I assume we can merge the master branch into site? If
I hear no objections, I'll do so and redeploy and hopefully that fixes
things. We'll have to keep an eye on this and hopefully someone who
experiences the problem when building the site can figure out what's
going on.

--
Michael Mior
mm...@apache.org
Le ven. 20 juil. 2018 à 12:03, Sergey Nuyanzin  a écrit :
>
> Hello everyone
>
> Just faced several issues with the site cacite.apache.org
> there are some links are unavailable from the main page (I checked only
> from the main)
>
> here it is the list of broken pages
> -- Release 1.17.0 (At the same time the page is available at
> http://calcite.apache.org/docs/history.html#v1-17-0)
> -- Calcite adds 5 committers
> -- Algebra builder
> -- Calcite adds 2 committers
> -- 1.17.0
>
> --
> Best regards,
> Sergey

Re: Several pages at calcite.apache.org are unavailable

[Volodymyr Vysotskyi]

Hi all,

Thanks Sergey for pointing out this issue and thanks Michael for looking
into the problem.

I broke it when deployed the site after the release, sorry for that.
I ran site locally and checked this page on my machine before pushing, and
all worked fine locally.
For some reason, these pages weren't pushed to
https://svn.apache.org/repos/asf/calcite/site.

I have no objections connected with merging the master branch into site.
Thanks a lot for fixing it.

Kind regards,
Volodymyr Vysotskyi


On Fri, Jul 20, 2018 at 7:22 PM Michael Mior  wrote:

> It looks like this builds correctly on my machine. Now that the
> release is out, I assume we can merge the master branch into site? If
> I hear no objections, I'll do so and redeploy and hopefully that fixes
> things. We'll have to keep an eye on this and hopefully someone who
> experiences the problem when building the site can figure out what's
> going on.
>
> --
> Michael Mior
> mm...@apache.org
> Le ven. 20 juil. 2018 à 12:03, Sergey Nuyanzin  a
> écrit :
> >
> > Hello everyone
> >
> > Just faced several issues with the site cacite.apache.org
> > there are some links are unavailable from the main page (I checked only
> > from the main)
> >
> > here it is the list of broken pages
> > -- Release 1.17.0 (At the same time the page is available at
> > http://calcite.apache.org/docs/history.html#v1-17-0)
> > -- Calcite adds 5 committers
> > -- Algebra builder
> > -- Calcite adds 2 committers
> > -- 1.17.0
> >
> > --
> > Best regards,
> > Sergey
>

[jira] [Created] (CALCITE-2422) Query with unnest of column from nested subquery fails when dynamic table is used

[Volodymyr Vysotskyi (JIRA)]

Volodymyr Vysotskyi created CALCITE-2422:


 Summary: Query with unnest of column from nested subquery fails 
when dynamic table is used
 Key: CALCITE-2422
 URL: https://issues.apache.org/jira/browse/CALCITE-2422
 Project: Calcite
  Issue Type: Bug
Reporter: Volodymyr Vysotskyi
Assignee: Julian Hyde


This test:
{code:java}
  @Test public void testStarDynamicSchemaUnnestNestedSubquery() {
String sql3 = "select * \n"
+ "from (select * from SALES.CUSTOMER) as t1,\n"
+ "unnest(t1.fake_col) as t2";
sql(sql3).with(getTesterWithDynamicTable()).ok();
  }
{code}
placed in {{SqlToRelConverterTest}} fails with {{AssertionError}}:
{noformat}
java.lang.AssertionError
at 
org.apache.calcite.sql.SqlUnnestOperator.inferReturnType(SqlUnnestOperator.java:81)
at 
org.apache.calcite.sql.SqlOperator.validateOperands(SqlOperator.java:437)
at 
org.apache.calcite.sql.validate.UnnestNamespace.validateImpl(UnnestNamespace.java:67)
at 
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:968)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:944)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3032)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3017)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:3069)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3026)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3275)
at 
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
at 
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:968)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:944)
at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:919)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:629)
at 
org.apache.calcite.test.SqlToRelTestBase$TesterImpl.convertSqlToRel(SqlToRelTestBase.java:642)
at 
org.apache.calcite.test.SqlToRelTestBase$TesterImpl.assertConvertsTo(SqlToRelTestBase.java:754)
at 
org.apache.calcite.test.SqlToRelConverterTest$Sql.convertsTo(SqlToRelConverterTest.java:2905)
at 
org.apache.calcite.test.SqlToRelConverterTest$Sql.ok(SqlToRelConverterTest.java:2897)
at 
org.apache.calcite.test.SqlToRelConverterTest.testStarDynamicSchemaUnnestNestedSubquery(SqlToRelConverterTest.java:2530)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at 
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at 
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at 
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
at 
com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
at 
com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
at 
com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
at 
com.intellij.rt.execution.junit.JUnitStarter.

Re: Several pages at calcite.apache.org are unavailable

[Michael Mior]

Do you mean you pushed to the git repository and pages didn't update
on the site or you committed to SVN and the pages you committed didn't
update?

--
Michael Mior
mm...@uwaterloo.ca

Le ven. 20 juil. 2018 à 12:56, Volodymyr Vysotskyi
 a écrit :
>
> Hi all,
>
> Thanks Sergey for pointing out this issue and thanks Michael for looking
> into the problem.
>
> I broke it when deployed the site after the release, sorry for that.
> I ran site locally and checked this page on my machine before pushing, and
> all worked fine locally.
> For some reason, these pages weren't pushed to
> https://svn.apache.org/repos/asf/calcite/site.
>
> I have no objections connected with merging the master branch into site.
> Thanks a lot for fixing it.
>
> Kind regards,
> Volodymyr Vysotskyi
>
>
> On Fri, Jul 20, 2018 at 7:22 PM Michael Mior  wrote:
>
> > It looks like this builds correctly on my machine. Now that the
> > release is out, I assume we can merge the master branch into site? If
> > I hear no objections, I'll do so and redeploy and hopefully that fixes
> > things. We'll have to keep an eye on this and hopefully someone who
> > experiences the problem when building the site can figure out what's
> > going on.
> >
> > --
> > Michael Mior
> > mm...@apache.org
> > Le ven. 20 juil. 2018 à 12:03, Sergey Nuyanzin  a
> > écrit :
> > >
> > > Hello everyone
> > >
> > > Just faced several issues with the site cacite.apache.org
> > > there are some links are unavailable from the main page (I checked only
> > > from the main)
> > >
> > > here it is the list of broken pages
> > > -- Release 1.17.0 (At the same time the page is available at
> > > http://calcite.apache.org/docs/history.html#v1-17-0)
> > > -- Calcite adds 5 committers
> > > -- Algebra builder
> > > -- Calcite adds 2 committers
> > > -- 1.17.0
> > >
> > > --
> > > Best regards,
> > > Sergey
> >

Re: Several pages at calcite.apache.org are unavailable

[Vova Vysotskyi]

I committed to SVN, but not all pages were pushed.

Пт, 20 лип. 2018 20:30 користувач Michael Mior  пише:

> Do you mean you pushed to the git repository and pages didn't update
> on the site or you committed to SVN and the pages you committed didn't
> update?
>
> --
> Michael Mior
> mm...@uwaterloo.ca
>
> Le ven. 20 juil. 2018 à 12:56, Volodymyr Vysotskyi
>  a écrit :
> >
> > Hi all,
> >
> > Thanks Sergey for pointing out this issue and thanks Michael for looking
> > into the problem.
> >
> > I broke it when deployed the site after the release, sorry for that.
> > I ran site locally and checked this page on my machine before pushing,
> and
> > all worked fine locally.
> > For some reason, these pages weren't pushed to
> > https://svn.apache.org/repos/asf/calcite/site.
> >
> > I have no objections connected with merging the master branch into site.
> > Thanks a lot for fixing it.
> >
> > Kind regards,
> > Volodymyr Vysotskyi
> >
> >
> > On Fri, Jul 20, 2018 at 7:22 PM Michael Mior  wrote:
> >
> > > It looks like this builds correctly on my machine. Now that the
> > > release is out, I assume we can merge the master branch into site? If
> > > I hear no objections, I'll do so and redeploy and hopefully that fixes
> > > things. We'll have to keep an eye on this and hopefully someone who
> > > experiences the problem when building the site can figure out what's
> > > going on.
> > >
> > > --
> > > Michael Mior
> > > mm...@apache.org
> > > Le ven. 20 juil. 2018 à 12:03, Sergey Nuyanzin  a
> > > écrit :
> > > >
> > > > Hello everyone
> > > >
> > > > Just faced several issues with the site cacite.apache.org
> > > > there are some links are unavailable from the main page (I checked
> only
> > > > from the main)
> > > >
> > > > here it is the list of broken pages
> > > > -- Release 1.17.0 (At the same time the page is available at
> > > > http://calcite.apache.org/docs/history.html#v1-17-0)
> > > > -- Calcite adds 5 committers
> > > > -- Algebra builder
> > > > -- Calcite adds 2 committers
> > > > -- 1.17.0
> > > >
> > > > --
> > > > Best regards,
> > > > Sergey
> > >
>

Re: Several pages at calcite.apache.org are unavailable

[Michael Mior]

Interesting. I pushed my update to the site and everything seems fine
for me. I noticed that the generated HTML for the latest release was
not present in SVN. Perhaps you forgot to do an svn add?

--
Michael Mior
mm...@apache.org
Le ven. 20 juil. 2018 à 13:35, Vova Vysotskyi  a écrit :
>
> I committed to SVN, but not all pages were pushed.
>
> Пт, 20 лип. 2018 20:30 користувач Michael Mior  пише:
>
> > Do you mean you pushed to the git repository and pages didn't update
> > on the site or you committed to SVN and the pages you committed didn't
> > update?
> >
> > --
> > Michael Mior
> > mm...@uwaterloo.ca
> >
> > Le ven. 20 juil. 2018 à 12:56, Volodymyr Vysotskyi
> >  a écrit :
> > >
> > > Hi all,
> > >
> > > Thanks Sergey for pointing out this issue and thanks Michael for looking
> > > into the problem.
> > >
> > > I broke it when deployed the site after the release, sorry for that.
> > > I ran site locally and checked this page on my machine before pushing,
> > and
> > > all worked fine locally.
> > > For some reason, these pages weren't pushed to
> > > https://svn.apache.org/repos/asf/calcite/site.
> > >
> > > I have no objections connected with merging the master branch into site.
> > > Thanks a lot for fixing it.
> > >
> > > Kind regards,
> > > Volodymyr Vysotskyi
> > >
> > >
> > > On Fri, Jul 20, 2018 at 7:22 PM Michael Mior  wrote:
> > >
> > > > It looks like this builds correctly on my machine. Now that the
> > > > release is out, I assume we can merge the master branch into site? If
> > > > I hear no objections, I'll do so and redeploy and hopefully that fixes
> > > > things. We'll have to keep an eye on this and hopefully someone who
> > > > experiences the problem when building the site can figure out what's
> > > > going on.
> > > >
> > > > --
> > > > Michael Mior
> > > > mm...@apache.org
> > > > Le ven. 20 juil. 2018 à 12:03, Sergey Nuyanzin  a
> > > > écrit :
> > > > >
> > > > > Hello everyone
> > > > >
> > > > > Just faced several issues with the site cacite.apache.org
> > > > > there are some links are unavailable from the main page (I checked
> > only
> > > > > from the main)
> > > > >
> > > > > here it is the list of broken pages
> > > > > -- Release 1.17.0 (At the same time the page is available at
> > > > > http://calcite.apache.org/docs/history.html#v1-17-0)
> > > > > -- Calcite adds 5 committers
> > > > > -- Algebra builder
> > > > > -- Calcite adds 2 committers
> > > > > -- 1.17.0
> > > > >
> > > > > --
> > > > > Best regards,
> > > > > Sergey
> > > >
> >

Calcite adapter for Cosmos DB ...

[Rohit Koimattur]

Hi,

I am  working for Citrix here at Santa Clara, wherein we are building a
security analytics cloud based solution for various Citrix products.

As part of that we intend to use Calcite SQL Query processor for Cosmos DB.
I didn't find a corresponding adapter for the same. Just like how Calcite
does provide a JDBC  adapater, Cassandra, MongoDB etc ?


Could you please keep me posted if the Calcite adapter is available for
Cosmos DB and if so, where can I access those details ? Would appreciate
your help and expecting a response at your earliest.


Thanks
Rohit

Re: User defined functions

[Julian Hyde]

Someone would need to modify the JDBC adapter so that if it connects to Oracle 
it would interrogate Oracle’s catalog to find the UDFs in Oracle. I don’t know 
if there’s a way to find UDFs generically (i.e. that relies only on JDBC, not 
knowing what flavor of database you are connecting to).

> On Jul 20, 2018, at 12:54 AM, Stamatis Zampetakis  wrote:
> 
> Hello Subbarao,
> 
> I am not sure, I understand what you want to achieve.
> 
> I suppose you are using the JdbcSchema (directly or indirectly), most
> likely through the JDBC Adapter.
> If that's the case then probably the reason that you don't see the
> user-defined functions is that the getFunctions() method is not yet
> implemented.
> 
> Best,
> Stamatis
> 
> 2018-07-12 7:12 GMT+02:00 subbarao mitta :
> 
>> Hi how to add existing user defined functions in Oracle database to schema
>> in calcite.I am connected Oracle database using schema but I don't know how
>> to add existing user defined functions to schema.
>> 

Re: Calcite adapter for Cosmos DB ...

[Michael Mior]

As far as I'm aware, there is no adapter for Cosmos DB nor is any in
development. We'd be happy to accept a contribution if you decide to
write one :) However, given that Cosmos DB already has a SQL API
(https://docs.microsoft.com/en-us/azure/cosmos-db/sql-api-introduction)
it's not clear to me what extra value the adapter would provide. There
does appear to be an existing JDBC driver for Cosmos DB
(https://www.cdata.com/drivers/cosmosdb/jdbc/) that would enable
Calcite integration.

--
Michael Mior
mm...@apache.org
Le ven. 20 juil. 2018 à 14:06, Rohit Koimattur
 a écrit :
>
> Hi,
>
> I am  working for Citrix here at Santa Clara, wherein we are building a
> security analytics cloud based solution for various Citrix products.
>
> As part of that we intend to use Calcite SQL Query processor for Cosmos DB.
> I didn't find a corresponding adapter for the same. Just like how Calcite
> does provide a JDBC  adapater, Cassandra, MongoDB etc ?
>
>
> Could you please keep me posted if the Calcite adapter is available for
> Cosmos DB and if so, where can I access those details ? Would appreciate
> your help and expecting a response at your earliest.
>
>
> Thanks
> Rohit

Re: User defined functions

[Michael Mior]

I'm not sure if this is implemented by Oracle, but there is
DatabaseMetaData#getFunctions.

https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getFunctions(java.lang.String,%20java.lang.String,%20java.lang.String)

--
Michael Mior
mm...@apache.org
Le ven. 20 juil. 2018 à 14:11, Julian Hyde  a écrit :
>
> Someone would need to modify the JDBC adapter so that if it connects to 
> Oracle it would interrogate Oracle’s catalog to find the UDFs in Oracle. I 
> don’t know if there’s a way to find UDFs generically (i.e. that relies only 
> on JDBC, not knowing what flavor of database you are connecting to).
>
> > On Jul 20, 2018, at 12:54 AM, Stamatis Zampetakis  wrote:
> >
> > Hello Subbarao,
> >
> > I am not sure, I understand what you want to achieve.
> >
> > I suppose you are using the JdbcSchema (directly or indirectly), most
> > likely through the JDBC Adapter.
> > If that's the case then probably the reason that you don't see the
> > user-defined functions is that the getFunctions() method is not yet
> > implemented.
> >
> > Best,
> > Stamatis
> >
> > 2018-07-12 7:12 GMT+02:00 subbarao mitta :
> >
> >> Hi how to add existing user defined functions in Oracle database to schema
> >> in calcite.I am connected Oracle database using schema but I don't know how
> >> to add existing user defined functions to schema.
> >>
>

Re: Calcite adapter for Cosmos DB ...

[Rohit Koimattur]

Could you please respond to the query?

Thanks
Rohit
On Thu, Jul 19, 2018 at 11:54 PM Rohit Koimattur 
wrote:

> Hi,
>
> I am  working for Citrix here at Santa Clara, wherein we are building a
> security analytics cloud based solution for various Citrix products.
>
> As part of that we intend to use Calcite SQL Query processor for Cosmos
> DB. I didn't find a corresponding adapter for the same. Just like how
> Calcite does provide a JDBC  adapater, Cassandra, MongoDB etc ?
>
>
> Could you please keep me posted if the Calcite adapter is available for
> Cosmos DB and if so, where can I access those details ? Would appreciate
> your help and expecting a response at your earliest.
>
>
> Thanks
> Rohit
>

Re: Several pages at calcite.apache.org are unavailable

[Julian Hyde]

When I push the site I have to remember to do adds and deletes (e.g. javadoc 
for classes that have been moved or renamed). I execute ‘svn status’ and look 
for lines starting ‘?’.


> On Jul 20, 2018, at 10:46 AM, Michael Mior  wrote:
> 
> Interesting. I pushed my update to the site and everything seems fine
> for me. I noticed that the generated HTML for the latest release was
> not present in SVN. Perhaps you forgot to do an svn add?
> 
> --
> Michael Mior
> mm...@apache.org
> Le ven. 20 juil. 2018 à 13:35, Vova Vysotskyi  a écrit :
>> 
>> I committed to SVN, but not all pages were pushed.
>> 
>> Пт, 20 лип. 2018 20:30 користувач Michael Mior  пише:
>> 
>>> Do you mean you pushed to the git repository and pages didn't update
>>> on the site or you committed to SVN and the pages you committed didn't
>>> update?
>>> 
>>> --
>>> Michael Mior
>>> mm...@uwaterloo.ca
>>> 
>>> Le ven. 20 juil. 2018 à 12:56, Volodymyr Vysotskyi
>>>  a écrit :
 
 Hi all,
 
 Thanks Sergey for pointing out this issue and thanks Michael for looking
 into the problem.
 
 I broke it when deployed the site after the release, sorry for that.
 I ran site locally and checked this page on my machine before pushing,
>>> and
 all worked fine locally.
 For some reason, these pages weren't pushed to
 https://svn.apache.org/repos/asf/calcite/site.
 
 I have no objections connected with merging the master branch into site.
 Thanks a lot for fixing it.
 
 Kind regards,
 Volodymyr Vysotskyi
 
 
 On Fri, Jul 20, 2018 at 7:22 PM Michael Mior  wrote:
 
> It looks like this builds correctly on my machine. Now that the
> release is out, I assume we can merge the master branch into site? If
> I hear no objections, I'll do so and redeploy and hopefully that fixes
> things. We'll have to keep an eye on this and hopefully someone who
> experiences the problem when building the site can figure out what's
> going on.
> 
> --
> Michael Mior
> mm...@apache.org
> Le ven. 20 juil. 2018 à 12:03, Sergey Nuyanzin  a
> écrit :
>> 
>> Hello everyone
>> 
>> Just faced several issues with the site cacite.apache.org
>> there are some links are unavailable from the main page (I checked
>>> only
>> from the main)
>> 
>> here it is the list of broken pages
>> -- Release 1.17.0 (At the same time the page is available at
>> http://calcite.apache.org/docs/history.html#v1-17-0)
>> -- Calcite adds 5 committers
>> -- Algebra builder
>> -- Calcite adds 2 committers
>> -- 1.17.0
>> 
>> --
>> Best regards,
>> Sergey
> 
>>> 

Re: Calcite adapter for Cosmos DB ...

[Julian Hyde]

Rohit,

You sent one message at midnight, and another at 8am. Please be a bit more 
patient.

There is no 24x7 platinum support for this project, and please remember that 
the support engineers earn $0 per hour.

Also, you should subscribe to the dev list. Your messages were sitting awaiting 
moderation.

Julian




> On Jul 20, 2018, at 8:18 AM, Rohit Koimattur  wrote:
> 
> Could you please respond to the query?
> 
> Thanks
> Rohit
> On Thu, Jul 19, 2018 at 11:54 PM Rohit Koimattur 
> wrote:
> 
>> Hi,
>> 
>> I am  working for Citrix here at Santa Clara, wherein we are building a
>> security analytics cloud based solution for various Citrix products.
>> 
>> As part of that we intend to use Calcite SQL Query processor for Cosmos
>> DB. I didn't find a corresponding adapter for the same. Just like how
>> Calcite does provide a JDBC  adapater, Cassandra, MongoDB etc ?
>> 
>> 
>> Could you please keep me posted if the Calcite adapter is available for
>> Cosmos DB and if so, where can I access those details ? Would appreciate
>> your help and expecting a response at your earliest.
>> 
>> 
>> Thanks
>> Rohit
>> 

Site branch merge

[Julian Hyde]

Michael,

I saw you merged the site branch. I had been thinking of instead doing a rebase.

I did a test rebase a few days ago and was pleased to see that it went smoothly 
— meaning that every commit in “site” had also been made to “master” — and it 
ended up pointing to the same commit as master.

In my opinion, merge commits are fine in personal repos but they are not great 
in public repos because they usually obfuscate history. (Maybe I just haven’t 
found the right tools to view them.) In this case, I think ‘git checkout site; 
git rebase origin/master; git push origin site’ would have been better.

Julian

Re: Site branch merge

[Vladimir Sitnikov]

>In my opinion, merge commits are fine in personal repos but they are not
great in public repos because they usually obfuscate history
>In this case, I think ‘git checkout site; git rebase origin/master; git
push origin site’ would have been better.

+1

Vladimir

Re: Site branch merge

[Michael Mior]

I'm fine with that. I can always reset and do a force push.

--
Michael Mior
mm...@apache.org

Le ven. 20 juil. 2018 à 14:38, Julian Hyde  a écrit :
>
> Michael,
>
> I saw you merged the site branch. I had been thinking of instead doing a 
> rebase.
>
> I did a test rebase a few days ago and was pleased to see that it went 
> smoothly — meaning that every commit in “site” had also been made to “master” 
> — and it ended up pointing to the same commit as master.
>
> In my opinion, merge commits are fine in personal repos but they are not 
> great in public repos because they usually obfuscate history. (Maybe I just 
> haven’t found the right tools to view them.) In this case, I think ‘git 
> checkout site; git rebase origin/master; git push origin site’ would have 
> been better.
>
> Julian
>

Re: Site branch merge

[Andrew Pilloud]

 git log --simplify-merges is probably what you are looking for. Merges are
a important tool in busy public repos.

On Fri, Jul 20, 2018 at 2:49 PM Michael Mior  wrote:
I'm fine with that. I can always reset and do a force push.

--
Michael Mior
mm...@apache.org

Le ven. 20 juil. 2018 à 14:38, Julian Hyde  a écrit :
>
> Michael,
>
> I saw you merged the site branch. I had been thinking of instead doing a
rebase.
>
> I did a test rebase a few days ago and was pleased to see that it went
smoothly — meaning that every commit in “site” had also been made to
“master” — and it ended up pointing to the same commit as master.
>
> In my opinion, merge commits are fine in personal repos but they are not
great in public repos because they usually obfuscate history. (Maybe I just
haven’t found the right tools to view them.) In this case, I think ‘git
checkout site; git rebase origin/master; git push origin site’ would have
been better.
>
> Julian
>

On Fri, Jul 20, 2018 at 2:49 PM Michael Mior  wrote:

> I'm fine with that. I can always reset and do a force push.
>
> --
> Michael Mior
> mm...@apache.org
>
> Le ven. 20 juil. 2018 à 14:38, Julian Hyde  a écrit :
> >
> > Michael,
> >
> > I saw you merged the site branch. I had been thinking of instead doing a
> rebase.
> >
> > I did a test rebase a few days ago and was pleased to see that it went
> smoothly — meaning that every commit in “site” had also been made to
> “master” — and it ended up pointing to the same commit as master.
> >
> > In my opinion, merge commits are fine in personal repos but they are not
> great in public repos because they usually obfuscate history. (Maybe I just
> haven’t found the right tools to view them.) In this case, I think ‘git
> checkout site; git rebase origin/master; git push origin site’ would have
> been better.
> >
> > Julian
> >
>

Re: Site branch merge

[Julian Hyde]

Thanks for the tip, Andrew. I’ll give that a try. I may yet come to love merge 
commits!

I saw that Michael reset “site”. Thank you - I think it was the right choice in 
this case.


> On Jul 20, 2018, at 11:54 AM, Andrew Pilloud  wrote:
> 
>  git log --simplify-merges is probably what you are looking for. Merges are a 
> important tool in busy public repos.
> 
> On Fri, Jul 20, 2018 at 2:49 PM Michael Mior  > wrote:
> I'm fine with that. I can always reset and do a force push.
> 
> --
> Michael Mior
> mm...@apache.org 
> 
> Le ven. 20 juil. 2018 à 14:38, Julian Hyde  > a écrit :
> >
> > Michael,
> >
> > I saw you merged the site branch. I had been thinking of instead doing a 
> > rebase.
> >
> > I did a test rebase a few days ago and was pleased to see that it went 
> > smoothly — meaning that every commit in “site” had also been made to 
> > “master” — and it ended up pointing to the same commit as master.
> >
> > In my opinion, merge commits are fine in personal repos but they are not 
> > great in public repos because they usually obfuscate history. (Maybe I just 
> > haven’t found the right tools to view them.) In this case, I think ‘git 
> > checkout site; git rebase origin/master; git push origin site’ would have 
> > been better.
> >
> > Julian
> >
> 
> On Fri, Jul 20, 2018 at 2:49 PM Michael Mior  > wrote:
> I'm fine with that. I can always reset and do a force push.
> 
> --
> Michael Mior
> mm...@apache.org 
> 
> Le ven. 20 juil. 2018 à 14:38, Julian Hyde  > a écrit :
> >
> > Michael,
> >
> > I saw you merged the site branch. I had been thinking of instead doing a 
> > rebase.
> >
> > I did a test rebase a few days ago and was pleased to see that it went 
> > smoothly — meaning that every commit in “site” had also been made to 
> > “master” — and it ended up pointing to the same commit as master.
> >
> > In my opinion, merge commits are fine in personal repos but they are not 
> > great in public repos because they usually obfuscate history. (Maybe I just 
> > haven’t found the right tools to view them.) In this case, I think ‘git 
> > checkout site; git rebase origin/master; git push origin site’ would have 
> > been better.
> >
> > Julian
> >

Re: Site branch merge

[Michael Mior]

I actually didn't make any changes since you sent your message (site
still contains a merge commit). I'm happy with whatever direction
others want to take.

--
Michael Mior
mm...@apache.org
Le ven. 20 juil. 2018 à 18:32, Julian Hyde  a écrit :
>
> Thanks for the tip, Andrew. I’ll give that a try. I may yet come to love 
> merge commits!
>
> I saw that Michael reset “site”. Thank you - I think it was the right choice 
> in this case.
>
>
> > On Jul 20, 2018, at 11:54 AM, Andrew Pilloud  wrote:
> >
> >  git log --simplify-merges is probably what you are looking for. Merges are 
> > a important tool in busy public repos.
> >
> > On Fri, Jul 20, 2018 at 2:49 PM Michael Mior  > > wrote:
> > I'm fine with that. I can always reset and do a force push.
> >
> > --
> > Michael Mior
> > mm...@apache.org 
> >
> > Le ven. 20 juil. 2018 à 14:38, Julian Hyde  > > a écrit :
> > >
> > > Michael,
> > >
> > > I saw you merged the site branch. I had been thinking of instead doing a 
> > > rebase.
> > >
> > > I did a test rebase a few days ago and was pleased to see that it went 
> > > smoothly — meaning that every commit in “site” had also been made to 
> > > “master” — and it ended up pointing to the same commit as master.
> > >
> > > In my opinion, merge commits are fine in personal repos but they are not 
> > > great in public repos because they usually obfuscate history. (Maybe I 
> > > just haven’t found the right tools to view them.) In this case, I think 
> > > ‘git checkout site; git rebase origin/master; git push origin site’ would 
> > > have been better.
> > >
> > > Julian
> > >
> >
> > On Fri, Jul 20, 2018 at 2:49 PM Michael Mior  > > wrote:
> > I'm fine with that. I can always reset and do a force push.
> >
> > --
> > Michael Mior
> > mm...@apache.org 
> >
> > Le ven. 20 juil. 2018 à 14:38, Julian Hyde  > > a écrit :
> > >
> > > Michael,
> > >
> > > I saw you merged the site branch. I had been thinking of instead doing a 
> > > rebase.
> > >
> > > I did a test rebase a few days ago and was pleased to see that it went 
> > > smoothly — meaning that every commit in “site” had also been made to 
> > > “master” — and it ended up pointing to the same commit as master.
> > >
> > > In my opinion, merge commits are fine in personal repos but they are not 
> > > great in public repos because they usually obfuscate history. (Maybe I 
> > > just haven’t found the right tools to view them.) In this case, I think 
> > > ‘git checkout site; git rebase origin/master; git push origin site’ would 
> > > have been better.
> > >
> > > Julian
> > >
>

[jira] [Created] (CALCITE-2423) Intermittent failure of CassandraAdapterIT#testMaterializedView

[Michael Mior (JIRA)]

Michael Mior created CALCITE-2423:
-

 Summary: Intermittent failure of 
CassandraAdapterIT#testMaterializedView
 Key: CALCITE-2423
 URL: https://issues.apache.org/jira/browse/CALCITE-2423
 Project: Calcite
  Issue Type: Bug
  Components: cassandra
Reporter: Michael Mior


This seems to happen around half the time I run the test. If anyone has any 
ideas what might be going wrong, I'd appreciate some help. As a quick summary 
of what the test is doing, Cassandra allows users to define materialized views 
in the schema and these should be exposed to Calcite by the adapter to enable 
view-based query writing.

This is implemented using Hook.TRIMMED when the schema is created to add 
instances of MaterializedViewTable to the schema.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[ANNOUNCE] New committer: Sergey Nuyanzin

[Julian Hyde]

The PMC has just invited Sergey Nuyanzin to be a committer, and he has
accepted. Over the past few months, Sergey has made several
contributions toe Avatica, to Calcite's built-in functions, and to the
JDBC adapter.

Sergey, welcome! Feel free to tell us a little about yourself.

Julian

Re: [ANNOUNCE] New committer: Sergey Nuyanzin

[Michael Mior]

Congratulations Sergey and thank you for your continued contributions!
--
Michael Mior
mm...@apache.org
Le ven. 20 juil. 2018 à 19:19, Julian Hyde  a écrit :
>
> The PMC has just invited Sergey Nuyanzin to be a committer, and he has
> accepted. Over the past few months, Sergey has made several
> contributions toe Avatica, to Calcite's built-in functions, and to the
> JDBC adapter.
>
> Sergey, welcome! Feel free to tell us a little about yourself.
>
> Julian

Re: [ANNOUNCE] New committer: Sergey Nuyanzin

[Francis Chuang]

Congrats, Sergey!

On 21/07/2018 10:45 AM, Michael Mior wrote:

Congratulations Sergey and thank you for your continued contributions!
--
Michael Mior
mm...@apache.org
Le ven. 20 juil. 2018 à 19:19, Julian Hyde  a écrit :

The PMC has just invited Sergey Nuyanzin to be a committer, and he has
accepted. Over the past few months, Sergey has made several
contributions toe Avatica, to Calcite's built-in functions, and to the
JDBC adapter.

Sergey, welcome! Feel free to tell us a little about yourself.

Julian