Kinetica SQL (KiSQL)

1

kisql -?

1
2
3
4
5
6
7

Usage: kisql [-options]

where options include:

Connect:
     --url        <url>       Connect to this GPUdb URL.  Use either this option or -host/-port, but not both.  Can also be specificed by the
                              KI_URL environment variable

1
2

$ kisql --url https://abcdefg.cloud.kinetica.com/hijklmn/gpudb-0;RowsPerFetch=20000 --user kuser
kuser password:

1
2

Connection successful
Kinetica (kuser) => 

1

Kinetica (user) => \d

1
2
3
4
5
6

+-------------+----------------------+-------------------------------------+--------------+
| TABLE_CAT   | TABLE_SCHEM          | TABLE_NAME                          | TABLE_TYPE   |
+-------------+----------------------+-------------------------------------+--------------+
| Kinetica    | SYSTEM               | ITER                                | TABLE        |
| Kinetica    | kisql_example        | product                             | TABLE        |
+-------------+----------------------+-------------------------------------+--------------+

1

Kinetica (user) => SELECT COUNT(*) AS total_products FROM kisql_example.product;

1
2
3
4
5

+------------------+
|   total_products |
+------------------+
|               14 |
+------------------+

1
2
3
4
5

kisql --url https://abcdefg.cloud.kinetica.com/hijklmn/gpudb-0;RowsPerFetch=20000 \
      --isql \
      --showTime false \
      --format delim --delim ',' \
      --sql 'SELECT * FROM kisql_example.product'

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15

id,category,name,description,stock
1,Furniture,Clamp-on Lamps,Strong, steadfast fasteners; localized lighting for laboring,10
2,Furniture,Desk Chairs,Soft, supportive seats enabling employment of exceptionally ergonomic endeavors,20
3,Office Supplies,Air Purifiers,Fast filter for odius odors & pesky particulates,4
4,Office Supplies,Binder Clips,Banker's clip, a.k.a. bobby clip, a.k.a. big clamp,10000
5,Office Supplies,Binding Machines,Top tech for trussing treatises,2
6,Office Supplies,Business Envelopes,Convenient containers for conventional communications,1000
7,Office Supplies,Business Cards,Identifying information with corporate iconography for industrious individuals,1000000
8,Technology,Power Strips,Dedicated energy-efficient devices for effectively delivering distributed electricity,50
9,Technology,Business Copiers,Diligent, durable duplicators of documents and diagrams,3
10,Technology,CD-R,'Write once; read many',100000
11,Technology,Conference Phones,Crystal-clear collaborative communication in a convenient, contemporary casing,11
12,Technology,Corded Keyboards,Tactile tools for troublesome tethered typing,1
13,Technology,Cordless Keyboards,Classy contrivances for conventionally connectionless keying,101
14,Technology,Dot Matrix Printers,Impactful industrial implements for impressing ink iteratively,27

1

Kinetica (user) => CREATE DIRECTORY 'kisql_dir';

1

Kinetica (user) => UPLOAD FILES 'products.csv' INTO 'kisql_dir';

1

Kinetica (user) => LOAD INTO kisql_example.product FROM FILE PATHS 'kifs://kisql_dir/products.csv';