Stack Overflow
Stack Overflow

Questions tagged [sqlline]

SQLLine is a pure-Java console-based utility for connecting to relational databases and executing SQL commands. It is similar to other command-line database access utilities like sqlplus for Oracle, mysql for MySQL, and isql for Sybase/SQL Server. Since it is pure-Java, it is platform independent and will run on any platform that can run Java 1.3 or higher.

SQLLine is a pure-Java console-based utility for connecting to relational databases and executing SQL commands. It is similar to other command-line database access utilities like sqlplus for Oracle, mysql for MySQL, and isql for Sybase/SQL Server. Since it is pure-Java, it is platform independent and will run on any platform that can run Java 1.3 or higher.

The simplest method for installing SQLLine in a platform independant way is as follows:

  1. Create a new directory/folder where you like. This will be referred to as sqllinedir.

  2. Download sqlline.jar into sqllinedir.

  3. Download the latest jline.jar from https://jline.github.io/ into sqllinedir.

  4. Download your database's JDBC driver files into sqllinedir. Note that some JDBC drivers require some installation, such as uncompressing or unzipping.

For various commands, you may refer http://sqlline.sourceforge.net/#issuing_sql

39 questions
1
vote
1 answer

Apache Phoenix client not able to connect with remote hbase server via Zookeper

I have a problem connecting an Apache Phoenix JDBC client (I'm using sqlline.py for test purposes) to my Hbase, from any remote computer. The way I'm testing is the following: I ssh to another machine running linux and then try to connect to my…
Christian Wirth
  • 123
  • 1
  • 9
0
votes
1 answer

How to rerun a command from sqlline's command history?

I can retrieve a command history from sqlline 1.9.0 using !history, for example: 0: jdbc:phoenix:> !history 139 16:45:44 SELECT DISTINCT BIOBANKSUBJECTID FROM VCF; ... 145 20:06:20 !/139 146 20:06:30 !rerun 139 147 20:07:00 !rerun…
kc2001
  • 5,008
  • 4
  • 51
  • 92
0
votes
1 answer

Apache Ignite querying _val and _ver columns via sqline

I am just starting with Apache Ignite and getting errors querying _val and _ver columns. Using latest docker image: docker run -it -e "CONFIG_URI=https://raw.githubusercontent.com/apache/ignite/master/examples/config/example-cache.xml"…
enotpolaskun
  • 51
  • 5
0
votes
1 answer

Does Apache Ignite really need to use the very old version of sqlline which has issues & missing certain features?

I see that Apache Ignite (and the GG editions for that matter) uses a very old version of sqlline which has issues & missing certain features. The version used is 1.3.0 which is from 2017, whereas the latest version is 1.12.0. The reason this comes…
lmk
  • 654
  • 5
  • 21
0
votes
1 answer

how to read content in a .txt file that is limited by two words in C ++

I am new with C++, I have a file that contains the following lines: ~~ 13!-!43?? CaKnX5H83G ~~ 107!-!22?? ~~ 140!-!274?? ~~ 233!-!75?? begin ~~ 143!-!208?? 143 ~~ 246!-!138?? ~~ 79!-!141?? vC5FxcKEiN ~~ 60!-!201?? 83 end ~~ 234!-!253?? ~~…
Phd student
  • 25
  • 1
  • 1
  • 8
0
votes
0 answers

Ignite Authentication - REST API ERROR in response

{"successStatus":2,"error":"The user name or password is incorrect [userName=[testuser]]","sessionToken":null,"response":null} Getting this REST API response on triggering authorization call for Ignite with following command: curl…
Shubham Shirur
  • 31
  • 5
0
votes
1 answer

Map JSON CDC data in cache value to Ignite sqlline thin client tables

Basically, I am trying to send CDC JSON data via connectors from Kafka topics to Ignite Cache. And for transformation purpose I want to look up this JSON data in table view in Ignite. How can I map these JSON fields to ignite SQLline table's…
Shubham Shirur
  • 31
  • 5
0
votes
1 answer

Create a key value table using apache ignite sqlline

I am trying to make a table using apache ignite 2.9.1 sqlline option. It's value part should have collection of generic key value pairs. It is very important. I want to create following type table I want to know , can I do this using using apache…
Pol
  • 11
  • 2
0
votes
2 answers

Creating Table in Ignite using sqlline

I am new to Ignite and trying to setup ignite in my MacOs. Then want to create one table in Ignite using sqline.I am using fallowing Steps. 1.Ignite Download: 2. Set Ignite Path. export IGNITE_HOME=“/Users/username/apps/ …
Sonu
  • 77
  • 11
0
votes
0 answers

apache drill: "no current connection" error and "could not find or load main class sqlline.sqlline" error

I am using JDK: 1.8.0.281 and Drill: 1.18.0 on m1 Mac. I cannot start drill downloaded from https://drill.apache.org/download/ directly. It says could not find or load main class sqlline.sqlline. So I refer to…
fields1631
  • 21
  • 4
0
votes
1 answer

GridGain/ Ignite query list data type

I'm trying to figure out how to work with a list datatype in a Gridgain query, I have an object which has a field @QuerySqlField private final List expertGroupIds; that I can receive during selects but I can't manage to create an update…
Daniel Racolta
  • 33
  • 5
0
votes
1 answer

Connecting to JDBC database via Calcite driver using sqlline

I would like to connect to JDBC DB, e.g. Postgres, via Calcite driver using sqlline shell script wrapper included in the calcite git repo. I'm facing the problem how to specify the target JDBC Postgres driver. Initially I tried…
David Kubecka
  • 127
  • 1
  • 7
0
votes
0 answers

Ignite Connectivity Issues

We have 3 Nodes of Ignite 2.7.6 cluster where we defined off heap memory/data region "datawarm" with max size 10GB and persistence enabled. We are facing very strange issue for more than a month. While connecting via SQLLine or Java Thin Client API,…
sandipbhowmik
  • 91
  • 8
0
votes
1 answer

User Authentication in SQLLine

Is there any way to pass the user password manually without passing the password in the sqlline jdbc connection string (like below). We want that sqlline tool will ask to put the password to connect, how to achieve this. ./sqlline.sh --verbose=true…
sandipbhowmik
  • 91
  • 8
0
votes
2 answers

sqlline not showing all columns of a Ignite table on terminal

I've created a table in Ignite which has more than 20 columns. Now, on sqlline I can only see five columns of that table out of 20 columns when query the data like "select * from table_name". Is there any way to do that in sqlline?
sandipbhowmik
  • 91
  • 8
1
2
3