Re: Can we enable '-ea' in csv sqlline by default

2023-10-27 Thread Ran Tao
In fact, I already found the bug so I asked this question. How to reproduce: use calcite-1.20[1] sqlline run this sql. ```sql select t1.x from (values (1, 'a'), (2, 'b')) as t1(x, y) left join (values (1, 'a'), (2, 'b'

Re: Can we enable '-ea' in csv sqlline by default

2023-10-27 Thread Julian Hyde
I get how frustrating it must be for bugs to happen in tests but not from sqlline. Regarding example/csv/sqlline. I had forgotten that we have two copies of sqlline (and sqlline.bat). They arrived when we imported a different project, optiq-csv. Do the extra copies serve any useful purpose? If

Can we enable '-ea' in csv sqlline by default

2023-10-27 Thread Ran Tao
hi, community Currently I have encountered a case where when I run a certain query in csv sqlline, it runs correctly, but it fails in the IDE. The location of failure is a certain assertion. The reason is that running tests in the IDE will turn on -ea to activate assert by default, but sqlline

[jira] [Created] (CALCITE-4938) Upgrade SQLLine to 1.12.0

2021-12-13 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-4938: Summary: Upgrade SQLLine to 1.12.0 Key: CALCITE-4938 URL: https://issues.apache.org/jira/browse/CALCITE-4938 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-4890) Enable mavenLocal for sqlline

2021-11-17 Thread Sergey Nuyanzin (Jira)
Sergey Nuyanzin created CALCITE-4890: Summary: Enable mavenLocal for sqlline Key: CALCITE-4890 URL: https://issues.apache.org/jira/browse/CALCITE-4890 Project: Calcite Issue Type: Bug

SQLLine

2021-10-28 Thread Julian Hyde
Calcite developers, The SQLLine community is having a conversation about project governance, with options including moving to ASF or an ASF-like PMC model. SQLLine has many users but very few active developers. If you are a SQLLine user, then you are part of the community, and we would like to

[jira] [Created] (CALCITE-4506) Upgrade SQLLine to 1.10.0

2021-02-21 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-4506: Summary: Upgrade SQLLine to 1.10.0 Key: CALCITE-4506 URL: https://issues.apache.org/jira/browse/CALCITE-4506 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-4324) sqlline is broken

2020-10-09 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-4324: Summary: sqlline is broken Key: CALCITE-4324 URL: https://issues.apache.org/jira/browse/CALCITE-4324 Project: Calcite Issue Type: Bug Reporter

Re: Sqlline error when openning a model-based connection

2020-09-30 Thread Gramana, Zachary (GE Digital)
OpenJDK 13? Note that the runtime is able to find the required classes, it just doesn’t like what it finds. > On Sep 30, 2020, at 11:58 AM, Gramana, Zachary (GE Digital) wrote: > > Hi Everyone, > > Try as I might, I am unable to open a model-base

Re: Sqlline error when openning a model-based connection

2020-09-30 Thread Julian Hyde
tal) > wrote: > > Hi Everyone, > > Try as I might, I am unable to open a model-based connection with sqlline > (built via `./gradlew buildSqllineClasspath`). I have tried a number of > different release tags (calcite-1.23.0, calcite-1.24.0, and calcite-1.25.0) > and even manu

Sqlline error when openning a model-based connection

2020-09-30 Thread Gramana, Zachary (GE Digital)
Hi Everyone, Try as I might, I am unable to open a model-based connection with sqlline (built via `./gradlew buildSqllineClasspath`). I have tried a number of different release tags (calcite-1.23.0, calcite-1.24.0, and calcite-1.25.0) and even manually bumped sqline to 1.8.0 and 1.7.0--all

Question: executing sqlline with tpc+adapter

2020-05-19 Thread Tal Glanzman
, i have initialized calcite's objects such as the FrameworkConfig with Planner, Cost factory and my own rule sets. Using those objects i perform query planning (no execution as of now). This works well but, Now i try to operate it all through sqlline, but when i connect using the connection s

[jira] [Created] (CALCITE-3444) Upgrade SQLLine to 1.9.0, and solve "Class path contains multiple SLF4J bindings" problem

2019-10-24 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-3444: Summary: Upgrade SQLLine to 1.9.0, and solve "Class path contains multiple SLF4J bindings" problem Key: CALCITE-3444 URL: https://issues.apache.org/jira/browse/CA

Re: How do I enable logging/tracing in Apache Calcite using Sqlline?

2019-06-18 Thread Stamatis Zampetakis
t, but because you use the SqlLine, I > think this std output has been blocked. > > Best, > Danny Chan > 在 2019年6月17日 +0800 PM11:09,Pirk, Holger ,写道: > > Hi folks, > > > > I posted a question on SO (see < > https://stackoverflow.com/questions/56629738/how-do-i-e

Re: How do I enable logging/tracing in Apache Calcite using Sqlline?

2019-06-18 Thread Danny Chan
Have you configured the RollingFileAppender and the file path ? The default logger outputs to the std out, but because you use the SqlLine, I think this std output has been blocked. Best, Danny Chan 在 2019年6月17日 +0800 PM11:09,Pirk, Holger ,写道: > Hi folks, > > I posted a question o

Re: How do I enable logging/tracing in Apache Calcite using Sqlline?

2019-06-17 Thread Muhammad Gelbana
I assume you can specify the log level in the JVM options for SqlLine. The JVM option is on the website/docs. Probably the *how to* page. Thanks, Gelbana On Mon, Jun 17, 2019 at 5:09 PM Pirk, Holger wrote: > Hi folks, > > I posted a question on SO (see < > https://stackoverflo

How do I enable logging/tracing in Apache Calcite using Sqlline?

2019-06-17 Thread Pirk, Holger
Hi folks, I posted a question on SO (see <https://stackoverflow.com/questions/56629738/how-do-i-enable-logging-tracing-in-apache-calcite-using-sqlline>) but figured that I might get a better and/or quicker answer here (I am happy to copy responses from one to the other). Here is the qu

[jira] [Created] (CALCITE-3098) Upgrade SQLLine to 1.8.0

2019-05-28 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-3098: Summary: Upgrade SQLLine to 1.8.0 Key: CALCITE-3098 URL: https://issues.apache.org/jira/browse/CALCITE-3098 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-2958) Upgrade SQLLine to 1.7.0

2019-03-26 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-2958: Summary: Upgrade SQLLine to 1.7.0 Key: CALCITE-2958 URL: https://issues.apache.org/jira/browse/CALCITE-2958 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-2711) Upgrade SQLLine to 1.6.0

2018-11-26 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-2711: Summary: Upgrade SQLLine to 1.6.0 Key: CALCITE-2711 URL: https://issues.apache.org/jira/browse/CALCITE-2711 Project: Calcite Issue Type: Bug

Re: Vote for SQLLine release 1.6.0

2018-11-21 Thread Julian Hyde
For this release, 99% of the credit is due to Sergey Nuyanzin (also a Calcite committer). He has contributed countless excellent features. > On Nov 21, 2018, at 6:02 PM, Michael Mior wrote: > > Sounds excellent! Thanks to Julian (and other SQLLine committers) for > continuing

Re: Vote for SQLLine release 1.6.0

2018-11-21 Thread Michael Mior
Sounds excellent! Thanks to Julian (and other SQLLine committers) for continuing to push this forward :) -- Michael Mior mm...@apache.org Le mer. 21 nov. 2018 à 17:12, Julian Hyde a écrit : > Calcite developers and users, > > I have just started a vote for sqlline-1.6.0 on the SQ

Vote for SQLLine release 1.6.0

2018-11-21 Thread Julian Hyde
Calcite developers and users, I have just started a vote for sqlline-1.6.0 on the SQLLine dev list. If you are a SQLLine committer or user, please participate. Here is the thread: https://groups.google.com/forum/#!topic/sqlline-dev/SWHPzpyBwv0 <https://groups.google.com/forum/#!topic/sqll

Re: Sqlline and beeline

2018-09-12 Thread Sergey Nuyanzin
Thank you for pointing to beeline. will have a look at it. I would also have a look at Zeppelin as they took several classes of sqlline. At least I like their idea of completion for sql [1]. [1] https://github.com/apache/zeppelin/blob/0d746fa2e2787a661db70d74035120ae3516ace3/jdbc/src/main/java

Sqlline and beeline

2018-09-11 Thread Julian Hyde
As you may know, Hive has its own fork of sqlline called beeline. The code bases forked about 4 years ago and combining them again is unlikely. The Hive community continues to develop Beeline; some of the features are Hive-specific, but others are bug-fixes for core functionality or generally

Re: Sqlline release

2018-09-09 Thread Michael Mior
; > Thank you very much for recognition and releasing sqlline > > > > did several checks on final version: > > - Bumped dependency in Apache Calcite and compiled > > - Created custom command handler in calcite-csv-example, compiled and > added > > via commandha

[jira] [Created] (CALCITE-2543) Upgrade SQLLine to 1.5.0

2018-09-09 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-2543: Summary: Upgrade SQLLine to 1.5.0 Key: CALCITE-2543 URL: https://issues.apache.org/jira/browse/CALCITE-2543 Project: Calcite Issue Type: Bug

Re: Sqlline release

2018-09-09 Thread Arina Yelchiyeva
Thank you, Julian! Kind regards, Arina On Sun, Sep 9, 2018 at 8:20 AM Sergey Nuyanzin wrote: > Thank you very much for recognition and releasing sqlline > > did several checks on final version: > - Bumped dependency in Apache Calcite and compiled > - Created custom command han

Re: Sqlline release

2018-09-08 Thread Sergey Nuyanzin
Thank you very much for recognition and releasing sqlline did several checks on final version: - Bumped dependency in Apache Calcite and compiled - Created custom command handler in calcite-csv-example, compiled and added via commandhandler and -ch, checked simple new commands - Created custom

Re: Sqlline release

2018-09-08 Thread Julian Hyde
Turns out that Arina made *FOUR* PRs last night. (So much for the weekend!) Thank you - I put them all in. Release sqlline-1.5.0 is now final[1], and the binaries should be appearing on Maven Central in an hour or two. A big thanks to all of the contributors to this release but especially to

Re: Sqlline release

2018-09-08 Thread Julian Hyde
are displayed when using incorrect url / driver > - ran random queries > - checked randomly commands / session options > > Kind regards, > Arina > > > > On Sat, Sep 8, 2018 at 8:25 AM Julian Hyde wrote: > > > We have a release candidate for sqlline-1.5.0, based on &g

Re: Sqlline release

2018-09-08 Thread Arina Yelchiyeva
/ session options Kind regards, Arina On Sat, Sep 8, 2018 at 8:25 AM Julian Hyde wrote: > We have a release candidate for sqlline-1.5.0, based on > > https://github.com/julianhyde/sqlline/commit/73d5974b6e694154bc47172f65d56ae47aa536aa > . > > This is not an Apache relea

Re: Sqlline release

2018-09-07 Thread Julian Hyde
We have a release candidate for sqlline-1.5.0, based on https://github.com/julianhyde/sqlline/commit/73d5974b6e694154bc47172f65d56ae47aa536aa. This is not an Apache release, so there is no .tar.gz to look at, and no formal vote, but I'd appreciate if one or two people look it over. The j

Re: Sqlline release

2018-09-06 Thread Julian Hyde
We’re very close to an RC for sqlline-1.5.0. Arina is working to finalize https://github.com/julianhyde/sqlline/issues/106 <https://github.com/julianhyde/sqlline/issues/106>. This is going to be the biggest sqlline release for a long time. (Special thanks to Sergey Nuyanzin for many

Re: Sqlline release

2018-09-04 Thread Julian Hyde
We said first week of September. Now it’s the first release of September. I think I can make a release candidate for sqlline-1.5.0 in the next few days. (As a non-Apache project, there is no formal vote for releases, but I welcome feedback.) There are few issues/PRs[1][2][3] that require

Re: Sqlline release

2018-08-19 Thread Sergey Nuyanzin
Thank you for a good news. I've added a new PR based on this #86 and I guess in one or two days will add one more On Sun, Aug 19, 2018 at 7:06 PM Julian Hyde wrote: > I’ve pushed PR #86... > https://github.com/julianhyde/sqlline/commit/8e0061f113d89a11ca03f4b48eda3340fd00375c

Re: Sqlline release

2018-08-19 Thread Julian Hyde
I’ve pushed PR #86... https://github.com/julianhyde/sqlline/commit/8e0061f113d89a11ca03f4b48eda3340fd00375c <https://github.com/julianhyde/sqlline/commit/8e0061f113d89a11ca03f4b48eda3340fd00375c> I’ll try to get to your remaining PRs in the next few days. Keep up the good work!

Re: Sqlline release

2018-08-18 Thread Sergey Nuyanzin
Julian, thank you very much for merging about PR on which I would like to build to add one more improvement: currently there is only one https://github.com/julianhyde/sqlline/pull/86 (commit 340c3b1 ) >>Sergey and others, Is first week of September still a good timeframe for release? for

Re: Sqlline release

2018-08-18 Thread Julian Hyde
Sergey, I see a lot of pull requests for sqlline coming in from you… which is excellent! You have said in a previous thread that it would be helpful if some of them are merged to master because you want to build on that. So, could you give me an ordered list of PR numbers that are ready to

Re: Sqlline release

2018-08-09 Thread Julian Hyde
few ideas about some more improvements) > >> On Tue, Aug 7, 2018 at 5:29 AM Julian Hyde wrote: >> >> (Forgive the cross-posting. The sqlline dev list isn’t very active, and >> many of the sqlline community are in the calcite community. Please reply to >> calci

Re: Sqlline release

2018-08-07 Thread Sergey Nuyanzin
+1 for release at the same time I am ok to wait about a month (I have a few ideas about some more improvements) On Tue, Aug 7, 2018 at 5:29 AM Julian Hyde wrote: > (Forgive the cross-posting. The sqlline dev list isn’t very active, and > many of the sqlline community are in the c

Sqlline release

2018-08-06 Thread Julian Hyde
(Forgive the cross-posting. The sqlline dev list isn’t very active, and many of the sqlline community are in the calcite community. Please reply to calcite dev only.) There have been a number of enhancements to sqlline recently[1] (thanks, Sergey!). Is it time for a release of sqlline? Or

[jira] [Created] (CALCITE-2318) NumberFormatException while Sqlline start

2018-05-18 Thread Sergey Nuyanzin (JIRA)
Sergey Nuyanzin created CALCITE-2318: Summary: NumberFormatException while Sqlline start Key: CALCITE-2318 URL: https://issues.apache.org/jira/browse/CALCITE-2318 Project: Calcite Issue

[jira] [Created] (CALCITE-1994) Elasticsearch5 not working using sqlline

2017-09-29 Thread Kunwar Deep Singh (JIRA)
Kunwar Deep Singh created CALCITE-1994: -- Summary: Elasticsearch5 not working using sqlline Key: CALCITE-1994 URL: https://issues.apache.org/jira/browse/CALCITE-1994 Project: Calcite

[ANNOUNCE] SQLLine version 1.3.0

2017-05-31 Thread Julian Hyde
I am pleased to announce the release of SQLLine version 1.3.0. Thanks to Ben Poweski and Mike Mattozzi for contributions this release. There is a new '!nickname' command, support for JDK 9 and Athena, and enhancements to the '!record' and '!run' commands. For more

Towards sqlline release 1.3

2017-05-25 Thread Julian Hyde
As you may know, I maintain the sqlline utility[1]. I think it's about time for a release. I plan to make a release candidate about in about a week. If you have a feature or bug fix you'd like to contribute, now would be a good time. Holler if you need a few extra days. Julian

Re: Question about PQS sqlline-thin go through knox

2017-02-22 Thread Josh Elser
Shi, HTTP user authentication refers to the authentication between the Avatica client (in Phoenix parlance: sqlline-thin) and the Avatica server (Phoenix Query Server). The database user authentication refers to any authentication that is down at the JDBC level inside of the server. For

Question about PQS sqlline-thin go through knox

2017-02-22 Thread Shi Wang
Hi, Recently I am trying connect to PQS with sqlline-thin client and go through knox, but it throws 401 error java.lang.RuntimeException: Failed to execute HTTP Request, got HTTP/401 at org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl.send(AvaticaCommonsHttpClientImpl.java:138

Question about PQS sqlline-thin go through knox

2017-02-22 Thread Shi Wang
Hi, Recently I am trying connect to PQS with sqlline-thin client and go through knox, but it throws 401 error java.lang.RuntimeException: Failed to execute HTTP Request, got HTTP/401 at org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl.send(AvaticaCommonsHttpClientImpl.java:138

Time for a sqlline release?

2016-09-20 Thread Julian Hyde
It’s about time for a release of sqlline (which I maintain, and which is used by Calcite and several other projects in the ecosystem). But I’m a lazy maintainer. It’s not worth the effort to make a release since there aren’t many contributions since 1.9. Now’s the time to contribute. If a

[jira] [Created] (CALCITE-1308) Primary Keys for Phoenix table not recognized in sqlline.

2016-07-07 Thread Josh Elser (JIRA)
Josh Elser created CALCITE-1308: --- Summary: Primary Keys for Phoenix table not recognized in sqlline. Key: CALCITE-1308 URL: https://issues.apache.org/jira/browse/CALCITE-1308 Project: Calcite

Re: Calcite sqlline query hit avatica NoSuchMethodError?

2016-05-24 Thread Jinfeng Ni
t 8:15 AM, Jinfeng Ni wrote: >> >> Hi, >> >> I built calcite from today's master branch (commit id: >> f191a386aedaee05c6ffcc1d4b155193bfa4ca01). >> >> Try to run Calcite's sqlline, and hit the following error: >> >> !connect jdbc:calci

Re: Calcite sqlline query hit avatica NoSuchMethodError?

2016-05-24 Thread Julian Hyde
te 1.5). Julian > On May 24, 2016, at 8:15 AM, Jinfeng Ni wrote: > > Hi, > > I built calcite from today's master branch (commit id: > f191a386aedaee05c6ffcc1d4b155193bfa4ca01). > > Try to run Calcite's sqlline, and hit the following error: > > !conne

Calcite sqlline query hit avatica NoSuchMethodError?

2016-05-24 Thread Jinfeng Ni
Hi, I built calcite from today's master branch (commit id: f191a386aedaee05c6ffcc1d4b155193bfa4ca01). Try to run Calcite's sqlline, and hit the following error: !connect jdbc:calcite:model=core/target/test-classes/hsqldb-model.json admin admin !tables java.lang.NoSuchM

Re: sqlline not available after compile/install/package

2016-05-14 Thread Albert
thanks, this solves my issue. On Sun, May 15, 2016 at 12:09 AM, Julian Hyde wrote: > Try this: > > $ rm target/fullclasspath.txt > $ ./sqlline > > Does it work now? > > What java version? > > Julian > > > On May 14, 2016, at 12:58 AM, Albert wrote: > &

sqlline release 1.10

2016-05-14 Thread Julian Hyde
We're due for a sqlline release 1.10; 1.9 was a little over a year ago. But I'm lazy. I can't be bothered to make a release that has only 3 or 4 bug fixes/features since 1.9. Let's have one or two pull requests, and then I'll make 1.10. There are plenty of good ideas

Re: sqlline not available after compile/install/package

2016-05-14 Thread Julian Hyde
Try this: $ rm target/fullclasspath.txt $ ./sqlline Does it work now? What java version? Julian > On May 14, 2016, at 12:58 AM, Albert wrote: > > *calcite/* *(**master**)* $ ./sqlline > > [15:55:56] > > Picked up JAVA_TOOL_OPTIONS: -Dfile.encoding=UTF-8 > &g

sqlline not available after compile/install/package

2016-05-14 Thread Albert
*calcite/* *(**master**)* $ ./sqlline [15:55:56] Picked up JAVA_TOOL_OPTIONS: -Dfile.encoding=UTF-8 Error: Could not find or load main class sqlline.SqlLine Used to be there, does this mean I have to manually manage the SqlLine dependency now ? or I missed something? thanks

[jira] [Created] (CALCITE-1223) sqlline doesn't treat lines beginning with -- as comments

2016-04-30 Thread James Taylor (JIRA)
James Taylor created CALCITE-1223: - Summary: sqlline doesn't treat lines beginning with -- as comments Key: CALCITE-1223 URL: https://issues.apache.org/jira/browse/CALCITE-1223 Project: Ca