Database Reference
In-Depth Information
1. Open the Hadoop command line console and type
hive
to start the
Hive command-line console. Using the Hive command-line console,
create a flight_dept table using the following script:
Create Table flight_dept (flight_date
string,carrier_cd string,
airport_cd string,dep_time int,delay int)
Row Format Delimited Fields Terminated By ',';
2. Use the following script to load the table:
LOAD DATA LOCAL INPATH
'c:\sampledata\Flight_Dept_Perf.csv'
OVERWRITE INTO TABLE flight_dept;
3. Run the following query to verify the data was loaded. You should see
results similar to those shown in
Figure 11.11
:
Select * from flight_dept limit 10;
Figure 11.11
Verifying the data load.
4. Now that the data is accessible through a Hive table, you can load it into
PowerPivot using the ODBC driver. Open Excel and click the
PowerPivot tab. On the PowerPivot tab, click Manage to open the
PowerPivot window (see
Figure 11.12
)
.
