[
https://issues.apache.org/jira/browse/DRILL-1954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14270061#comment-14270061
]
Cary Greenwood commented on DRILL-1954:
---------------------------------------
Thanks Jacques!
The work around did the trick. Unfortunately it wasn't very pretty:
CREATE TABLE fcc_cellular AS select columns[0] as LICENSE_ID, columns[1] as
SOURCE_SYSTEM, columns[2] as CALLSIGN, columns[3] as FACILITY_ID, columns[4] as
FRN, columns[5] as LIC_NAME, columns[6] as COMMON_NAME, columns[7] as
RADIO_SERVICE_CODE, columns[8] as RADIO_SERVICE_DESC, columns[9] as
ROLLUP_CATEGORY_CODE, columns[10] as ROLLUP_CATEGORY_DESC, columns[11] as
GRANT_DATE, columns[12] as EXPIRED_DATE, columns[13] as CANCELLATION_DATE,
columns[14] as LAST_ACTION_DATE, columns[15] as LIC_STATUS_CODE, columns[16] as
LIC_STATUS_DESC, columns[17] as ROLLUP_STATUS_CODE, columns[18] as
ROLLUP_STATUS_DESC, columns[19] as ENTITY_TYPE_CODE, columns[20] as
ENTITY_TYPE_DESC, columns[21] as ROLLUP_ENTITY_CODE, columns[22] as
ROLLUP_ENTITY_DESC, columns[23] as LIC_ADDRESS, columns[24] as LIC_CITY,
columns[25] as LIC_STATE, columns[26] as LIC_ZIP_CODE, columns[27] as
LIC_ATTENTION_LINE, columns[28] as CONTACT_COMPANY, columns[29] as
CONTACT_NAME, columns[30] as CONTACT_TITLE, columns[31] as CONTACT_ADDRESS1,
columns[32] as CONTACT_ADDRESS2, columns[33] as CONTACT_CITY, columns[34] as
CONTACT_STATE, columns[35] as CONTACT_ZIP, columns[36] as CONTACT_COUNTRY,
columns[37] as CONTACT_PHONE, columns[38] as CONTACT_FAX, columns[39] as
CONTACT_EMAIL, columns[40] as MARKET_CODE, columns[41] as MARKET_DESC,
columns[42] as CHANNEL_BLOCK, columns[43] as LOC_TYPE_CODE, columns[44] as
LOC_TYPE_DESC, columns[45] as LOC_CITY, columns[46] as LOC_COUNTY_CODE,
columns[47] as LOC_COUNTY_NAME, columns[48] as LOC_STATE, columns[49] as
LOC_RADIUS_OP, columns[50] as LOC_SEQ_ID, columns[51] as LOC_LAT_DEG,
columns[52] as LOC_LAT_MIN, columns[53] as LOC_LAT_SEC, columns[54] as
LOC_LAT_DIR, columns[55] as LOC_LONG_DEG, columns[56] as LOC_LONG_MIN,
columns[57] as LOC_LONG_SEC, columns[58] as LOC_LONG_DIR, columns[59] as
HGT_STRUCTURE, columns[60] as ASR_NUM, columns[61] as ANTENNA_ID, columns[62]
as ANT_SEQ_ID, columns[63] as ANT_MAKE, columns[64] as ANT_MODEL, columns[65]
as ANT_TYPE_CODE, columns[66] as ANT_TYPE_DESC, columns[67] as AZIMUTH,
columns[68] as BEAMWIDTH, columns[69] as POLARIZATION_CODE, columns[70] as
FREQUENCY_ID, columns[71] as FREQ_SEQ_ID, columns[72] as
FREQ_CLASS_STATION_CODE, columns[73] as FREQ_CLASS_STATION_DESC, columns[74] as
POWER_ERP, columns[75] as POWER_OUTPUT, columns[76] as FREQUENCY_ASSIGNED,
columns[77] as FREQUENCY_UPPER_BAND, columns[78] as UNIT_OF_MEASURE,
columns[79] as TOLERANCE, columns[80] as EMISSION_ID, columns[81] as
EMISSION_SEQ_ID, columns[82] as EMISSION_CODE, columns[83] as GROUND_ELEVATION
from dfs.`/Users/carygreenwood/Documents/fcc/fcc_lic_vw.csv` WHERE columns[10]
IN ('"Mobile/Fixed Broadband"', '"Fixed Wireless"') AND columns[17] = '"A"';
I will be looking forward to the update!
C
> Update CSV Writer to treat a single RepeatedVarChar column as separate
> columns on output rather than Erroring
> -------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-1954
> URL: https://issues.apache.org/jira/browse/DRILL-1954
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Text & CSV
> Affects Versions: 0.6.0, 0.7.0
> Reporter: Cary Greenwood
> Fix For: 1.0.0
>
>
> I am experiencing this error when attempting to create a table. When the
> same query is executed using SELECT * the results display fine.
> 0: jdbc:drill:zk=local> CREATE TABLE fcc_cell AS select * from
> dfs.`/Users/Documents/fcc/fcc_lic_vw.csv` WHERE columns[10] IN
> ('"Mobile/Fixed Broadband"', '"Fixed Wireless"') AND columns[17] = '"A"';
> Query failed: Query stopped., Repeated types are not supported. [
> cd76d8fd-b00e-47d5-962c-6566381b17fb on 192.168.1.4:31010 ]
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
