Re: Cannot connect to hive

2019-06-21 Thread Valeriy Trofimov
.2x), the following configuration works well. > (jdbcCatalog=null, jdbcSchema=db_name) > Therefore, maybe you need to add a line in your Shema's json > .. > jdbcSchema: 'thrift' > . > > Best, > DonnyZone > > Valeriy Trofimov

Re: Cannot connect to hive

2019-06-19 Thread Valeriy Trofimov
untime.Resources$ExInstWithCause.ex(Resources.java:463) at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572) ... 54 more Thanks, Val On Tue, Jun 18, 2019 at 7:39 PM Zhu Feng wrote: > Hi Valeriy, > I remember that "jdbcCatalog" and "jdbcSchema" should be c

Cannot connect to hive

2019-06-18 Thread Valeriy Trofimov
Hi All, I'm trying to connect to Hive DB via Thrift JDBC Server. I get error: "Object 'test' not found within 'thrift'". The error occurs by the IdentifierNamespace.resolveImpl() method. The method checks that schema looks correct based on my query. Schema: { version: '1.0', schemas: [

Re: Null collation error when connecting to Hive DB

2019-06-14 Thread Valeriy Trofimov
ssues.apache.org/jira/browse/HIVE-12994>. > > > > > On Jun 14, 2019, at 11:21 AM, Valeriy Trofimov > wrote: > > > > Hi All, > > > > I'm using Calcite to connect to Hive DB via JDBC adapter that connects to > > Thrift JDBC server running on a VM with S

Null collation error when connecting to Hive DB

2019-06-14 Thread Valeriy Trofimov
Hi All, I'm using Calcite to connect to Hive DB via JDBC adapter that connects to Thrift JDBC server running on a VM with Spark and Hive installed there. The schema looks like this: { name: 'thrift', type: 'custom', factory: 'org.apache.calcite.adapter.jdbc.JdbcSchema$Factory', operand:

Re: Customizing Join Algorithm

2019-05-16 Thread Valeriy Trofimov
write a rule that transforms Join RelNode with > your > > algorithm. Is that what you want to do? > > > > ig > > > > > > > > > > > > From: Valeriy Trofimov > > Sent: Thursday, May 16, 2019 9:47 PM > > To: dev@cal

Customizing Join Algorithm

2019-05-16 Thread Valeriy Trofimov
Hi All, I want to use a custom join algorithm in Calcite SQL join queries. My questions are: 1. Is it possible to do? 2. If yes, what part of Calcite should I update? I've tried to figure it out myself by debugging Calcite join unit tests, but it looks like Calcite uses Avatica for this.

Re: inter-database queries

2019-05-09 Thread Valeriy Trofimov
Never mind, I've figured it out - you have to use fully qualified names like "schema1"."table1" and "schema2"."table2" Thanks, Val On Thu, May 9, 2019 at 4:39 PM Valeriy Trofimov wrote: > Hi All, > > How can I do inter-database join via Calcit

inter-database queries

2019-05-09 Thread Valeriy Trofimov
Hi All, How can I do inter-database join via Calcite? According to answer to similar question it's possible: https://stackoverflow.com/questions/31975457/apache-calcite-data-federation-usecase I've tried doing it but the issue seems to be that I can only use one schema for my queries, even

Re: calcite-test-dataset VM has issues with Druid

2019-04-25 Thread Valeriy Trofimov
Same with following steps described at https://github.com/vlsi/calcite-test-dataset - running the "gfsh" command shows "gfsh: command not found" error On Thu, Apr 25, 2019 at 2:28 PM Valeriy Trofimov wrote: > > Hi All, > > Executing steps described at these li

calcite-test-dataset VM has issues with Druid

2019-04-25 Thread Valeriy Trofimov
Hi All, Executing steps described at these links https://calcite.apache.org/docs/howto.html#running-integration-tests https://github.com/vlsi/calcite-test-dataset shows this error when accessing Druid data: curl: (7) Failed to connect to localhost port 8082: Connection refused Using "vagrant

[jira] [Created] (CALCITE-2974) Timestamp conversion performance can be improved

2019-04-02 Thread Valeriy Trofimov (JIRA)
Valeriy Trofimov created CALCITE-2974: - Summary: Timestamp conversion performance can be improved Key: CALCITE-2974 URL: https://issues.apache.org/jira/browse/CALCITE-2974 Project: Calcite