Database Reference
In-Depth Information
$impala-shell -i Impala-Server-Name:PORT -f
SQL_Script_Name.sql
Here is the execution of the preceding SQL script:
[cloudera@localhost ~]$ impala-shell -i
localhost.localdomain:21000 -f autos_setup.sql
Connected to localhost.localdomain:21000
Server version: impalad version 1.0.1 RELEASE
(build df844fb967cec8740f08dfb8b21962bc053527ef)
Query: use default
Query: drop DATABASE IF EXISTS autos
Query: create DATABASE autos
Query: use autos
Query: drop TABLE IF EXISTS automobiles
Query: create EXTERNAL TABLE automobiles ( make
STRING, model STRING, autoyear INTEGER,
fuelType STRING, numOfDoors INTEGER, design
STRING, autoType STRING, cylinders INTEGER,
horsePower INTEGER, city_hwy_mpg STRING, price
FLOAT) ROW FORMAT DELIMITED FIELDS TERMINATED
BY ',' STORED AS TEXTFILE LOCATION '/user/
cloudera/automobiles'
Query: drop TABLE IF EXISTS automakers
Query: create EXTERNAL TABLE automakers
(autoMaker STRING)
