I am trying to run a simple SQL query against a warehouse db and I keep getting the error User Requested Cancel of Operation after a while. I'm only running 1 month of data. I'm leaving the timeout box blank. Any suggestions? Below is the full sql statement.
select "Dispatch_Date"."FULL_DATE" "Dispatch_Date", "Invoice_Date"."FULL_DATE" "Invoice_Date", "Company"."COMPANY_CODE" "Company_Code", "Trade"."TRADE_GRP_CODE" "Trade_Group", "Dispatch_Info"."PREFERRED_VENDOR_IND" "Preferred_Vendor_", case when nvl("Sales_Channel"."SALES_CHANNEL", 'NULL')='RN' then case when nvl("Sales_Channel"."ORIGINAL_SALES_CHANNEL", 'NULL')='DC' then case when "Sales_Channel"."TPV_FLAG"='Y' then '3P_RENEWAL' else 'NON_3P_RENEWAL' end else 'RE_RENEWAL' end when nvl("Sales_Channel"."SALES_CHANNEL", 'NULL')='DC' then case when "Sales_Channel"."TPV_FLAG"='Y' then '3P_1ST_YEAR' else 'NON_3P_1ST_YEAR' end else 'RE_1ST_YEAR' end "ACCT01_Channels", "Geography"."STATE_CODE" "State_Code", "Geography"."MARKET_AREA" "Market_Area", "Invoice_Info"."INVOICE_TYPE_CODE" "Invoice_Type", sum("Atomic_Invoice"."INVOICE_GROSS_AMOUNT") "Invoice_Gross_Amount", sum("Atomic_Invoice"."DISCOUNTED_GROSS_AMOUNT") "Discounted_Amount", sum("Atomic_Invoice"."SVC_FEE_COLLECTED") "Service_Fee_Collected", count(distinct "Atomic_Invoice"."INVOICE_ID") "Invoice"
from "YEAR1"."DW_DATE" "Dispatch_Date", "YEAR1"."DW_DATE" "Invoice_Date", "YEAR1"."DW_COMPANY" "Company", "YEAR1"."DW_TRADES" "Trade", "YEAR1"."DW_SWO_INFO" "Dispatch_Info", "YEAR1"."DW_SALES_CHANNEL" "Sales_Channel", "YEAR1"."DW_GEOGRAPHY" "Geography", "YEAR1"."DW_SWO_INV_INFO" "Invoice_Info", "YEAR1"."ATOMIC_SWO_INV" "Atomic_Invoice"
where "Dispatch_Date"."YYYYMM">'201612' and "Dispatch_Date"."SK_DATE"="Atomic_Invoice"."SK_DISPATCH_DATE" and "Sales_Channel"."SK_SALES_CHANNEL"="Atomic_Invoice"."SK_SALES_CHANNEL" and "Company"."SK_COMPANY"="Atomic_Invoice"."SK_COMPANY" and "Trade"."SK_TRADES"="Atomic_Invoice"."SK_TRADES" and "Invoice_Info"."SK_SWO_INV_INFO"="Atomic_Invoice"."SK_SWO_INV_INFO" and "Dispatch_Info"."SK_SWO_INFO"="Atomic_Invoice"."SK_SWO_INFO" and "Geography"."SK_GEOGRAPHY"="Atomic_Invoice"."SK_GEOGRAPHY" and "Invoice_Date"."SK_DATE"="Atomic_Invoice"."SK_INVOICE_DATE"
group by "Invoice_Info"."INVOICE_TYPE_CODE", "Dispatch_Info"."PREFERRED_VENDOR_IND", "Dispatch_Date"."FULL_DATE", "Invoice_Date"."FULL_DATE", "Company"."COMPANY_CODE", "Trade"."TRADE_GRP_CODE", case when nvl("Sales_Channel"."SALES_CHANNEL", 'NULL')='RN' then case when nvl("Sales_Channel"."ORIGINAL_SALES_CHANNEL", 'NULL')='DC' then case when "Sales_Channel"."TPV_FLAG"='Y' then '3P_RENEWAL' else 'NON_3P_RENEWAL' end else 'RE_RENEWAL' end when nvl("Sales_Channel"."SALES_CHANNEL", 'NULL')='DC' then case when "Sales_Channel"."TPV_FLAG"='Y' then '3P_1ST_YEAR' else 'NON_3P_1ST_YEAR' end else 'RE_1ST_YEAR' end , "Geography"."STATE_CODE", "Geography"."MARKET_AREA"
