Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Apache Drill

Apache Drill

Explorer

I am trying to create tables in apache drill from csv file, using the query:

 

create table sdp_d(WID, BATCH_ID, SRC_ID, ORG_ID, CLASS_WID, DESC_TEXT, PREMISE_WID,FEED_LOC, GPS_LAT, GPS_LONG, PULSE_OUTPUT_BLOCK, UDC_ID, UNIVERSAL_ID,
IS_VIRTUAL_FLG,SEAL_INFO, ACCESS_INFO, ALT_ACCESS_INFO, LOC_INFO, ALT_LOC_INFO, TYPE, SUB_TYPE, TIMEZONE_ID, GIS_ID, BILLED_UPTO_TIME, POWER_STATUS, LOAD_STATUS,
BILLING_HOLD_STATUS, INSERT_TIME,LAST_UPD_TIME) as select cast(columns[0] as INT) as WID, cast(columns[1] as INT) as BATCH_ID, cast(columns[2] as CHAR(30)) as SRC_ID,
cast(columns[3] as INT) as ORG_ID, cast(columns[4] as INT) as CLASS_WID, cast(columns[5] as CHAR(30)) as DESC_TEXT, cast(columns[6] as INT) as PREMISE_WID, cast
(columns[7] as CHAR(30)) as FEED_LOC, cast(columns[8] as DOUBLE) as GPS_LAT, cast(columns[9] as DOUBLE) as GPS_LONG, cast(columns[10] as CHAR(30)) as
PULSE_OUTPUT_BLOCK, cast(columns[11] as CHAR(30)) as UDC_ID, cast(columns[12] as CHAR(30)) as UNIVERSAL_ID, cast(columns[13] as CHAR(30)) as IS_VIRTUAL_FLG, cast
(columns[14] as CHAR(30)) as SEAL_INFO, cast(columns[15] as CHAR(30)) as ACCESS_INFO, cast(columns[16] as CHAR(30)) as ALT_ACCESS_INFO, cast(columns[17] as CHAR(30))
as LOC_INFO, cast(columns[18] as CHAR(30)) as ALT_LOC_INFO, cast(columns[19] as CHAR(30)) as TYPE, cast(columns[20] as CHAR(30)) as SUB_TYPE, cast(columns[21] as INT)
as TIMEZONE_ID, cast(columns[22] as CHAR(30)) as GIS_ID, cast(columns[23] as TIMESTAMP) as BILLED_UPTO_TIME, cast(columns[24] as CHAR(30)) as POWER_STATUS, cast
(columns[25] as CHAR(30)) as LOAD_STATUS, cast(columns[26] as CHAR(30)) as BILLING_HOLD_STATUS, cast(columns[27] as TIMESTAMP) as INSERT_TIME, cast(columns[28] as
TIMESTAMP) as LAST_UPD_TIME from hdfstest.`/user/spark/sdp_output.csv`;

 

In the same way I have created the other tables as well, but while creating this table I am getting error: 

 

Error: SYSTEM ERROR: NumberFormatException: 435

Fragment 0:0

[Error Id: dca447ca-8558-4a04-89af-76cfc0c94ddc on quickstart.cloudera:31010] (state=,code=0)

 

Does any one have any idea that what could be the reason for this error?

2 REPLIES 2

Re: Apache Drill

Master Collaborator

Sorry, Drill is not a component in CDH. Seek help via drill.apache.org.

Highlighted

Re: Apache Drill

Contributor

Dear All.

 

Plz make sure...whether Drill tools available in cloudera or not?

 

 

 

Thanks

HadoopHelp

Don't have an account?
Coming from Hortonworks? Activate your account here