Hi, I am using tBigQueryinput to get some data and connect them to PostgreSQL. I run the query in BigQuery directly and it works. However, when i run it in Talend I get this error. Do you have any idea what it might mean? Thanks a lot!
Starting job channels_daily at 00:05 21/04/2016.
[size=1][font=Courier][statistics] connecting to socket on port 3446[/font][/size] [size=1][font=Courier][statistics] connected[/font][/size] [size=1][font=Courier]Running Query : select brand, platform, funnel_type, date, device, channel, sum(case when total = 1 and listing = 1 then 1 end) listing, sum(case when listing = 1 and menu = 1 then 1 end) menu, sum(case when menu = 1 and checkout = 1 then 1 end) checkout, sum(case when checkout = 1 and transaction = 1 then 1 else 0 end) transaction from ( select 'LH' as brand, 'Android' as platform, 'Microfunnel' as funnel_type,CONCAT(fullVisitorId,STRING(visitId)) as session_id, date, device.deviceCategory as device, CASE WHEN trafficSource.medium = 'organic' THEN 'SEO' WHEN trafficSource.campaign like '%sem_bra_%' AND trafficSource.medium = 'cpc' THEN 'SEM Brand' WHEN trafficSource.campaign like '%dis_%' AND trafficSource.medium = 'cpc' THEN 'Display' WHEN trafficSource.campaign not like '%dis_%' AND trafficSource.campaign not like '%sem_bra_%' AND trafficSource.medium = 'cpc' THEN 'SEM Non-Brand' WHEN trafficSource.medium = 'referral' THEN 'Referrer' WHEN trafficSource.medium = '%affiliate%' THEN 'Affiliate' WHEN trafficSource.source like '%direct%' THEN 'Direct' WHEN trafficSource.medium = 'display' THEN 'Display' WHEN trafficSource.medium = 'social' THEN 'Social Media Engagement' WHEN trafficSource.medium = 'crm' THEN 'CRM' WHEN trafficSource.medium = 'offline' THEN 'Offline' WHEN trafficSource.medium = 'coops' THEN 'Cooperations' WHEN trafficSource.medium = 'app' THEN 'Mobile' ELSE 'undefined' END AS channel,IF(sum(if(hits.eventInfo.eventAction is null,1,0))>0,1,0) as total,IF(sum(if(hits.eventInfo.eventAction = 'shop_list.loaded', 1,0))>0,1,0) as listing,IF(sum(if(hits.eventInfo.eventAction = 'shop_details.loaded', 1,0))>0,1,0) as menu,IF(sum(if(hits.eventInfo.eventAction = 'checkout.loaded', 1,0))>0,1,0) as checkout,IF(sum(if(hits.transaction.transactionId is not null, 1,0))>0,1,0) as transaction FROM TABLE_DATE_RANGE([107101250.ga_sessions_],TIMESTAMP(DATE_ADD(TIMESTAMP(current_date()),-20,'DAY')),CURRENT_TIMESTAMP()) group by 1,2,3,4,5,6,7) foo group by 1,2,3,4,5,6[/font][/size] Exception in component tBigQueryInput_1 java.lang.IndexOutOfBoundsException: Index: 10, Size: 10 at java.util.ArrayList.rangeCheck(ArrayList.java:653) at java.util.ArrayList.get(ArrayList.java:429) at dhh_bi_v10.channels_daily_0_1.channels_daily.tBigQueryInput_1Process(channels_daily.java:2770) at dhh_bi_v10.channels_daily_0_1.channels_daily.runJobInTOS(channels_daily.java:8370) at dhh_bi_v10.channels_daily_0_1.channels_daily.main(channels_daily.java:7999) [size=1][font=Courier][statistics] disconnected[/font][/size]
[color=#0433ff][size=1][font=Courier]Job channels_daily ended at 00:05 21/04/2016. [exit code=1][/font][/size][/color]
