CREATE EXTERNAL TABLE db_student.customer (
CustomerID String,
Gender String,
SeniorCitizen Int,
Partner String,
Dependents String,
Tenure Int,
PhoneService String,
MultipleLines String,
InternetService String,
OnlineSecurity String,
OnlineBackup String,
DeviceProtection String,
TechSupport String,
StreamingTV String,
StreamingMovies String,
Contract String,
PaperlessBilling String,
PaymentMethod String,
MonthlyCharges Float,
TotalCharges Float,
Churn String)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
'hbase.columns.mapping'=':key,id:g,id:sc,id:p,id:d,id:t,srv:ps,srv:ml,srv:is,srv:os,srv:ob,srv:dp,srv:ts,srv:stv,srv:sm,val:c,val:pb,val:pm,val:mc,val:tc,val:ch')
TBLPROPERTIES(
'hbase.table.name' = 'ns_student:customer',
'hbase.mapred.output.outputtable' = 'ns_student:customer');