[
https://issues.apache.org/jira/browse/DRILL-5557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16028756#comment-16028756
]
renlu commented on DRILL-5557:
------------------------------
the query :
CREATE TABLE `pvlog-20170523` AS SELECT
sid,
case when body_w = '' then CAST(NULL AS INT) else CAST(body_w AS INT) end
as body_w,
case when body_h = '' then CAST(NULL AS INT) else CAST(body_h AS INT) end
as body_h,
case when cd = '' then CAST(NULL AS INT) else CAST(cd AS INT) end AS cd,
case when datetime = '' then CAST(NULL AS DATE) else CAST(`datetime` AS
DATE) end as datetime,
`dateString`,
case when debug = '' then CAST(NULL AS INT) else CAST(debug AS INT) end as
debug,domain,uid,cookie,ip,ua,SUBSTR(`ref`,200) as `ref`,
case when sh = '' then CAST(NULL AS INT) else CAST(sh AS INT) end as sh,
case when sw = '' then CAST(NULL AS INT) else CAST(sw AS INT) end as sw,
case when ts='' then CAST(NULL as BIGINT) else CAST(ts as BIGINT) end as ts,
rn,
SUBSTR(url,200) as url,
CASE
WHEN os <> '' then os
WHEN ua LIKE '%Android%' then 'Android'
WHEN ua LIKE '%iPhone%' or ua like '%iPad%' then 'iOS'
WHEN ua LIKE '%Windows%' then 'Windows'
END as os,
browser,
browser_version,externalSource,externalDomain,page_id
FROM `entry.20170523.csv`
> java.lang.IndexOutOfBoundsException: writerIndex:
> --------------------------------------------------
>
> Key: DRILL-5557
> URL: https://issues.apache.org/jira/browse/DRILL-5557
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.10.0
> Reporter: renlu
>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
