Hello,
I get error on my oracle query: identifier is too long. However, even when I make the identifier or column names 5 letters long, it stil lgives me the same error.
More over, I am using the same "long" column names for another input tool with a slightly different query, it doesnt give me this error.
errorneous query:
SELECT
YEAR,
INSERT_TIMESTAMP,
AVG(AREANME) AS AREANME_PREVDAY_AVG,
AVG(REGIONAL) AS REGIONAL_PREVDAY_AVG,
AVG(NATIONAL) AS NATIONAL_PREVDAY_AVG,
AVG(CLIENT1_NAME_NULLS) AS gnpa--CLIENT1_NAME_NULLS_PREVDAY_AVG,
AVG(CLIENT2_NAME_NULLS) AS dnpa--CLIENT2_NAME_NULLS_PREVDAY_AVG,
AVG(SALES_TERRITORY_NULLS) AS stnpa--SALES_TERRITORY_NULLS_PREVDAY_AVG
FROM SEED_METRIC_LOG
WHERE TO_DATE(INSERT_TIMESTAMP, 'RRRR-MM-DD HH24:MI:SS') >= '27-jun-2024'
and year='2024'
group by YEAR,
INSERT_TIMESTAMP
non-errorneous query: slightly similar query but no errors in alteryx
SELECT
YEAR,
INSERT_TIMESTAMP,
AVG(AREANME) AS AREANME_PREVDAY_AVG,
AVG(REGIONAL) AS REGIONAL_PREVDAY_AVG,
AVG(NATIONAL) AS NATIONAL_PREVDAY_AVG,
AVG(CLIENT1_NAME_NULLS) AS CLIENT1_NAME_NULLS_PREVDAY_AVG,
AVG(CLIENT2_NAME_NULLS) AS CLIENT2_NAME_NULLS_PREVDAY_AVG,
AVG(SALES_TERRITORY_NULLS) AS SALES_TERRITORY_NULLS_PREVDAY_AVG
FROM METRIC_LOG
WHERE SUBSTR(TO_TIMESTAMP(INSERT_TIMESTAMP, 'RRRR-MM-DD HH24:MI:SS'),1,9) = (
SELECT INSERT_DATE FROM (
SELECT ROW_NUMBER() OVER(ORDER BY "Date_For_Entry" DESC) AS ROWNUM_,
SUBSTR("Date_For_Entry",1,9) AS INSERT_DATE
FROM DATA_TABLE
WHERE "Dataset_Name" = 'Name'
AND SUBSTR("Date_For_Entry",1,9) <> SUBSTR(CURRENT_TIMESTAMP,1,9)
)
WHERE ROWNUM_ = 1)
GROUP BY YEAR, INSERT_TIMESTAMP
ORDER BY YEAR DESC
