[localhost.localdomain:21000] > DROP TABLE IF EXISTS prospects;
Query: drop TABLE IF EXISTS prospects

[localhost.localdomain:21000] > CREATE TABLE prospects (
                              >   id INT, 
                              >   fname STRING, 
                              >   lname STRING, 
                              >   home_phone STRING, 
                              >   work_phone STRING, 
                              >   cell_phone STRING, 
                              >   age INT) 
                              > ROW FORMAT DELIMITED 
                              > FIELDS TERMINATED BY '\t';
Query: create TABLE prospects ( id INT, fname STRING, lname STRING, home_phone STRING, work_phone STRING, cell_phone STRING, age INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
Returned 0 row(s) in 2.13s


[localhost.localdomain:21000] > LOAD DATA INPATH '/tmp/tabledata.txt' INTO TABLE prospects;
Query: load DATA INPATH '/tmp/tabledata.txt' INTO TABLE prospects
+----------------------------------------------------------+
| summary                                                  |
+----------------------------------------------------------+
| Loaded 1 file(s). Total files in destination location: 1 |
+----------------------------------------------------------+
Returned 1 row(s) in 1.13s


[localhost.localdomain:21000] > SELECT count(*) FROM prospects;
Query: select count(*) FROM prospects
+----------+
| count(*) |
+----------+
| 5000     |
+----------+
Returned 1 row(s) in 0.85s


[localhost.localdomain:21000] > DROP TABLE IF EXISTS prospects_parq;
Query: drop TABLE IF EXISTS prospects_parq


[localhost.localdomain:21000] > CREATE TABLE prospects_parq LIKE prospects STORED AS PARQUET;
Query: create TABLE prospects_parq LIKE prospects STORED AS PARQUET
Returned 0 row(s) in 2.11s


[localhost.localdomain:21000] > INSERT INTO TABLE prospects_parq SELECT * FROM prospects;
Query: insert INTO TABLE prospects_parq SELECT * FROM prospects
Inserted 5000 rows in 1.63s


[localhost.localdomain:21000] > SELECT count(*) FROM prospects;
Query: select count(*) FROM prospects
+----------+
| count(*) |
+----------+
| 5000     |
+----------+
Returned 1 row(s) in 0.67s


[localhost.localdomain:21000] > SELECT count(*) FROM prospects_parq;
Query: select count(*) FROM prospects_parq
+----------+
| count(*) |
+----------+
| 5000     |
+----------+
Returned 1 row(s) in 0.67s