Re: Using Calcite in .Net environment

[F21]

If you want to talk to Calcite from .NET, the best way would be to use 
the Avatica server. It is an HTTP server that allows you to talk to the 
calcite backend using protobufs or JSON.


Here's a .NET client that talks to the Avatica server, but is currently 
targeted towards Apache Phoenix (which uses Avatica under the hood for 
its query server): https://github.com/Azure/hdinsight-phoenix-sharp


Cheers,
Francis

On 9/09/2016 6:26 AM, Rawat, Rishi wrote:

Hi Calcite team

We are trying to create a data virtualization engine in our technology stack 
which is a .Net/C# layer.
What is the best way in which we can achieve using Calcite from a .Net.

Also we are Sql server heavy in our operations(also data operations expanding 
to other data source types). Is there any example that we can try for sql 
server.


Thanks in advance.
Rishi


The information contained in this message is intended only for the recipient, and may be a 
confidential attorney-client communication or may otherwise be privileged and confidential and 
protected from disclosure. If the reader of this message is not the intended recipient, or an 
employee or agent responsible for delivering this message to the intended recipient, please be 
aware that any dissemination or copying of this communication is strictly prohibited. If you 
have received this communication in error, please immediately notify us by replying to the 
message and deleting it from your computer. S Global Inc. reserves the right, subject to 
applicable local law, to monitor, review and process the content of any electronic message or 
information sent to or from S Global Inc. e-mail addresses without informing the sender 
or recipient of the message. By sending electronic message or information to S Global 
Inc. e-mail addresses you, as the sender, are consenting to S Global Inc. processing any 
of your personal data therein.

Re: Import Calcite as a maven project in Eclipse

[Josh Elser]

Hi,

Can you provide an example class name which could not be found? Hard to 
guess at what the issue is without knowing what it can't find.


You could also try simply doing an "Import Maven Project" provided by 
m2e's integration instead of invoking `mvn eclipse:eclipse` to generate 
the configuration files. I import the project directly and have success 
with this.


- Josh

Γιώργος Θεοδωράκης wrote:

Hello, I am trying to import latest version of calcite in eclipse. I have
downloaded the source code from github as zip, used these commands:
$mvn install
$mvn eclipse:eclipse
and finally imported the project as an existing maven project. However, I
get many errors (in core's pom.xml , classes missing) and I don't know what
to do. Any suggestions?

Re: Simple Streaming Senario

[Γιώργος Θεοδωράκης]

After many tries, in order to build a streaming query application on csv in
Eclipse I used:
As maven dependencies:
- commons-io 2.4 , commons-logging 1.1.3 , commons-lang3 3.2 , janino 2.7.6
, eigenbase-properties 1.1.5 , avatica 1.8.0, opencsv 2.3 , json-simple 1.1

and as external jars :
calcite-core 1.9.0, example-csv-1.9.0, calcite-linq4j 1.9.0 after creating
them with mvn install command.

2016-09-06 21:15 GMT+03:00 Γιώργος Θεοδωράκης :

> I've tried with avatica, avatica-metrics, standalone-server and server,
> all in version 1.8.0 jars from maven repository as dependencies(at first
> only with avatica and avatica-metrics and then with other combinations) and
> 1.9.0-SNAPSHOT versions of calcite core and csv with their sources. At
> first I got an eigenbase-properties NoClass Exception, so I added version
> 1.1.5 from maven repositories. Then, I got java.lang.NoClassDefFoundError:
> org/codehaus/commons/compiler/CompileException , and I am stuck with
> these exception after many combinations and tries.
>
> 2016-09-06 18:46 GMT+03:00 Julian Hyde :
>
>> That still sounds like a version mismatch. Note that avatica releases are
>> separate from calcite these days. Therefore calcite-core-1.9.0-SNAPSHOT,
>> for instance, depends upon avatica-metrics-1.8.0.
>>
>> I think you should use 1.9.0-SNAPSHOT versions of calcite- jars, and
>> 1.8.0 versions of avatica- jars.
>>
>> Julian
>>
>>
>> > On Sep 6, 2016, at 7:45 AM, Γιώργος Θεοδωράκης 
>> wrote:
>> >
>> > I have imported as external jars calcite-example-csv, calcite-core,
>> avatica
>> > , linq4j, avatica-metrics, avatica-standalone with all their sources and
>> > tests, and I get: Exception in thread "main"
>> java.lang.AbstractMethodError:
>> > org.apache.calcite.config.CalciteConnectionProperty.valueCla‌
>> ​ss()Ljava/lang/Class‌​;
>> > at
>> > org.apache.calcite.avatica.ConnectionConfigImpl$PropEnv.getE‌
>> ​num(ConnectionConfig‌​Impl.java:228).
>> > Is there something else I am missing.
>> >
>> > Also, when I ran the streaming test from CsvTest.java and I add a
>> filter in
>> > the query, I get an error. Is filter implemented for streaming query by
>> > defining the query with a string, or should I define with another way?
>> >
>> >
>> > 2016-09-05 21:03 GMT+03:00 Julian Hyde :
>> >
>> >> You have mismatched versions. CANCEL_FLAG will be added to calcite-core
>> >> only in version 1.9. So, if you are using 1.9.0-SNAPSHOT version of
>> >> example/csv you should use a 1.9.0-SNAPSHOT version of other Calcite
>> jars.
>> >> (You can build and install in your local repo using ‘mvn install’.)
>> >>
>> >> 1.9 should be released in a couple of weeks.
>> >>
>> >> Julian
>> >>
>> >>> On Sep 5, 2016, at 3:04 AM, Γιώργος Θεοδωράκης <
>> giwrgosrth...@gmail.com>
>> >> wrote:
>> >>>
>> >>> It has to do with the dependencies. When I am running the sample code
>> >> with
>> >>> changes as Test in
>> >>> ../calcite-master/example/csv/src/test/java/org/apache/calcite/test/
>> I
>> >> have
>> >>> no errors. However, when I try to create my own project in Eclipse and
>> >>> after I  have imported everything with maven repositories (from
>> calcite
>> >> 1.8
>> >>> version and as external .jar the calcite-example-csv-1.9.0-SNAP
>> SHOT.jar
>> >>> from the github version) the same error occurs :
>> >>>
>> >>> Exception in thread "main" java.lang.NoSuchFieldError: CANCEL_FLAG
>> >>> at
>> >>> org.apache.calcite.adapter.csv.CsvScannableTable.scan(
>> >> CsvScannableTable.java:48)
>> >>> at
>> >>> org.apache.calcite.interpreter.TableScanNode.
>> >> createScannable(TableScanNode.java:117)
>> >>> at
>> >>> org.apache.calcite.interpreter.TableScanNode.
>> >> create(TableScanNode.java:94)
>> >>> at org.apache.calcite.interpreter.Nodes$CoreCompiler.visit(
>> Nodes.java:
>> >> 68)
>> >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> >>> at
>> >>> sun.reflect.NativeMethodAccessorImpl.invoke(
>> >> NativeMethodAccessorImpl.java:57)
>> >>> at
>> >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(
>> >> DelegatingMethodAccessorImpl.java:43)
>> >>> at java.lang.reflect.Method.invoke(Method.java:606)
>> >>> at
>> >>> org.apache.calcite.util.ReflectUtil.invokeVisitorInternal(
>> >> ReflectUtil.java:257)
>> >>> at org.apache.calcite.util.ReflectUtil.invokeVisitor(
>> >> ReflectUtil.java:214)
>> >>> at org.apache.calcite.util.ReflectUtil$1.invokeVisitor(
>> >> ReflectUtil.java:471)
>> >>> at
>> >>> org.apache.calcite.interpreter.Interpreter$Compiler.visit(
>> Interpreter.
>> >> java:476)
>> >>> at
>> >>> org.apache.calcite.interpreter.Interpreter$Compiler.visitRoot(
>> >> Interpreter.java:433)
>> >>> at org.apache.calcite.interpreter.Interpreter.
>> >> (Interpreter.java:75)
>> >>> at Baz.bind(Unknown Source)
>> >>> at
>> >>> org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(
>> >> CalcitePrepare.java:327)
>> >>> at
>> >>> 

Using Calcite in .Net environment

[Rawat, Rishi]

Hi Calcite team

We are trying to create a data virtualization engine in our technology stack 
which is a .Net/C# layer.
What is the best way in which we can achieve using Calcite from a .Net.

Also we are Sql server heavy in our operations(also data operations expanding 
to other data source types). Is there any example that we can try for sql 
server.


Thanks in advance.
Rishi


The information contained in this message is intended only for the recipient, 
and may be a confidential attorney-client communication or may otherwise be 
privileged and confidential and protected from disclosure. If the reader of 
this message is not the intended recipient, or an employee or agent responsible 
for delivering this message to the intended recipient, please be aware that any 
dissemination or copying of this communication is strictly prohibited. If you 
have received this communication in error, please immediately notify us by 
replying to the message and deleting it from your computer. S Global Inc. 
reserves the right, subject to applicable local law, to monitor, review and 
process the content of any electronic message or information sent to or from 
S Global Inc. e-mail addresses without informing the sender or recipient of 
the message. By sending electronic message or information to S Global Inc. 
e-mail addresses you, as the sender, are consenting to S Global Inc. 
processing any of your personal data therein.

Re: Making Calcite release 1.9

[Atri Sharma]

Just to update, my laptop does not seem to be able to mount a FAT system
for Virtualbox to run in order for me to execute the tests. If there is an
alternate way, please let me know.

Regards,

Atri

On Wed, Aug 24, 2016 at 1:56 AM, Julian Hyde  wrote:

> Unfortunately, the release manager has to be a committer. There are
> practical reasons (you need write access to several ASF systems) and legal
> ones (you are making the release on behalf of Apache).
>
> That said, I very much appreciate your offer to help. Could you help with
> the logistics? For example compiling release notes, running test builds,
> and chasing up the various JIRA cases and pull requests that are required
> in the release.
>
> The release instructions[1] describe the pre-release checks that need to
> be performed. If you did those the actual release would run more smoothly.
>
> Julian
>
> [1] https://calcite.apache.org/docs/howto.html#making-a-
> release-for-calcite-committers  docs/howto.html#making-a-release-for-calcite-committers>
>
> > On Aug 23, 2016, at 10:44 AM, Atri Sharma  wrote:
> >
> > I can be the release manager (my first time,so would need support and
> > bootstrapping, but would love to help).
> >
> > Regards,
> >
> > Atri
> >
> > On Tue, Aug 23, 2016 at 11:11 PM, Julian Hyde  wrote:
> >
> >> It’s time to start work on Calcite release 1.9, so we can hit the “end
> of
> >> August” target.
> >>
> >> Does this timeline (end of August) still work for everyone?
> >>
> >> Would anyone like to be release manager?
> >>
> >> Are there any issues that people would like to get into 1.9 (and are
> >> prepared to work on)?
> >>
> >> It should be quite a straightforward release. I have logged
> >> https://issues.apache.org/jira/browse/CALCITE-1356 <
> >> https://issues.apache.org/jira/browse/CALCITE-1356> to track.
> >>
> >> Julian
> >>
> >>
> >
> >
> > --
> > Regards,
> >
> > Atri
> > Apache Concerted
>
>


-- 
Regards,

Atri
*l'apprenant*

Import Calcite as a maven project in Eclipse

[Γιώργος Θεοδωράκης]

Hello, I am trying to import latest version of calcite in eclipse. I have
downloaded the source code from github as zip, used these commands:
$mvn install
$mvn eclipse:eclipse
and finally imported the project as an existing maven project. However, I
get many errors (in core's pom.xml , classes missing) and I don't know what
to do. Any suggestions?