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
18
votes
4 answers

Can not read large data from phoenix table

Hi All i am getting below error message while running phoenix count query on a large table. 0: jdbc:phoenix:hadoopm1:2181> select Count(*) from PJM_DATASET; +------------+ | COUNT(1) | +------------+ java.lang.RuntimeException:…
user3683741
  • 181
  • 1
  • 5
3
votes
2 answers

Apache Drill > sqlline: how to run a sql script containing variable

I am a newbie of Apache Drill, and I need to run a SQL script through sqlline. In most SQL client, it is allowed to use some variables in sqlline, so hereby I would like to ask that is it possible to use variables in sqlline of Apache Drill?
Rui
  • 3,454
  • 6
  • 37
  • 70
2
votes
1 answer

Composite key in Ignite

I've created a Ignite table via defining two columns as primary key (PK). When I tried to insert the data its failing with duplicate key error. PK defined on type and id column. 0: jdbc:ignite:thin://node1.example.com> insert into balance…
sandipbhowmik
  • 91
  • 8
2
votes
0 answers

Apache Phoenix unable to create schema

I am using Apache Phoenix and trying to create schema. Following are the versions used (psuedo-distributed installation) Hadoop - 2.6.4 Hbase - 1.1.2 Phoenix - 4.7.0 Sqlline - 1.1.8 Zookeper- 3.4.6 (Hbase default/ managed) I am ale to create…
Ekansh Rastogi
  • 2,418
  • 2
  • 14
  • 23
2
votes
1 answer

Phoenix sqlline can not query system table SYSTEM.FUNCTION

I know Apache Phoenix will store all function metadata in SYSTEM.FUNCTION, but when I perform the query use following statement it will throw exception. 0: jdbc:phoenix:10.1.226.15:2181> select * from SYSTEM.FUNCTION; Error: ERROR 604 (42P00):…
Jeffy Zhang
  • 111
  • 2
  • 11
1
vote
1 answer

Apache Ignite Load CSV data from Java think client

When loading the csv file using sqlline it works. When trying to use the copy from command using a java thin client connection, Facing the below issue. Here is the code: try (IgniteClient client = Ignition.startClient(cfg)) { String…
vinod nerella
  • 13
  • 4
1
vote
0 answers

How to find primary key columns of a table in ignite?

I have created a table in ignite using SQLLine and I want to see which columns in that table are the primary key. When i queried SYS.TABLE_COLUMNS I don't see the Primary key columns.Can someone please help me how can i get the primary key columns…
Sachin Janani
  • 1,310
  • 1
  • 17
  • 33
1
vote
1 answer

Displaying list of subitems in sqlline

In Ignite I have classes defined as below (with cache configuration for Persons): public class Person { @QuerySqlField(index = true) private long id; @QuerySqlField private String name; @QuerySqlField private List
…
wojciech
  • 11
  • 1
1
vote
1 answer

How Can I delete auto created SuperUser of Ignite

I have an Azure Kubernetes Service. I deployed the Apache Ignite image on it. It works well and I'm using ThinClient to connect to the Ignite. Also, authentication has been enabled. In the first deployment, Ignite creates a superuser that name and…
OguzKaanAkyalcin
  • 621
  • 2
  • 8
  • 25
1
vote
1 answer

How to do you insert array typeof data into apche ignite

I am trying to create a table with array data type in apache ignite using following query. create table test(id int,word varchar,vector array,primary key(id)); with this above query i am able to create a table test. 0 :…
ramojirao yalamati
  • 11
  • 3
1
vote
1 answer

Phoenix alter table add column fails

I am trying to add a column to an existing phoenix table using alter table command as below ALTER TABLE TABLE1 ADD "db_name" VARCHAR(20); Its failing with below warning WARN query.ConnectionQueryServicesImpl: Unable to update meta data repo within…
Dhananjay
  • 3,903
  • 2
  • 29
  • 44
1
vote
1 answer

Integrating Apache Cassandra with Apache Ignite

I'm trying to integrate Apache Ignite with Apache Cassandra(3.11.2) as I want to use Ignite to cache the data present in my already existing Cassandra database. After going through the online resources, I've done the following till now: Downloaded…
Vishal Sharma
  • 1,670
  • 20
  • 55
1
vote
1 answer

Cant connect Phoenix to Hbase using sqlline

I am using Hbase 1.2.6, phoenix-4.13.1-HBase-1.2, hadoop 2.9.0, in pseudo distributed setup. I can create tables in hbase shell, and I want to use phoenix to read those tables. I get the following error when running 'sqlline.py…
Sum of N upto Infinity
  • 83
  • 9
1
vote
1 answer

No known driver to handle "jdbc:calcite:model=druid/src/test/resources/druid-wiki-model.json

I am trying to run calcite and sqlline with druid. I downloaded the ZIP from calcite downloads website and put it inside the druid folder. When i try to run sqlline command !connect jdbc:calcite:model=druid/src/test/resources/druid-wiki-model.json…
Akshat G
  • 214
  • 2
  • 14
1
vote
2 answers

hbase.DoNotRetryIOException while reading using phoenix?

Hbase Version : 1.1.3 Phoenix Version : 4.7.0 After upserting the data I was able to read the data from Hbase using phoenix. After restarting the cluster I'm getting the following error Sqlline log 0: jdbc:phoenix:localhost> select count(*) from…
Vishnu667
  • 768
  • 1
  • 16
  • 39
1
2 3