Database Reference
In-Depth Information
Triumph,Speed
Triple,2001,gas,2,deluxe,sport,1050,150,false,23000
Suzuki,RGV250,2000,gas,2,deluxe,sport,249,127,false,7500
Triumph,Daytona,gas,2005,2,deluxe,sport,675,156,false,16000
Triumph,Street
Triple,2010,gas,2,casual,sport,123,141,true,12000
Ducati,1098,2010,gas,2,deluxe,sport,1099,180,false,30000
Harley,Tri
Glide,2012,gas,3,deluxe,luxury,1600,180,false,35000
Harley,Iron,2012,gas,casual,luxury,1500,200,false,14000
Bramo,Icon,2012,electric,2,casual,sport,4500,80,false,20000
Zero,Police,2013,electric,2,casual,sport,4300,95,false,25000
Can-am,spider,2014,gas,3,deluxe,luxury,998,120,false,22000
Data and schema considerations
You cannot use a dash (
-
) with the schema name; instead use an underscore. In the
preceding example's dataset schema, you can see some of the schema definition
are using underscores while others are not.
In your data, you must not have spaces between a separator; otherwise, numeric
values cannot be processed correctly or you will get
NULL
instead.
Note
Before we go further, I would like to make sure it is understood that the preceding
data is created by me, specifically for reference purpose to demonstrate Impala
query processing. This data is completely fabricated and does not reflect any cor-
rect information.
