Error 3706 teradata - Исправление ошибок и поиск оптимальных решений проблем

На чтение 3 мин Обновлено 18.01.2023

Ошибка Failure 3706 Syntax error: expected something between начало запроса и слово ‘tbuild’

Я получаю это сообщение об ошибке каждый раз, когда пытаюсь запустить самый-очень простой скрипт из этого tutorial. Я довольно новичок в Teradata, помогите пожалуйста:

BTEQ — Введите ваш SQL-запрос или команду BTEQ: tbuild -f /root/multiloadtest/TPT_Load.tpt; tbuild -f /root/multiloadtest/TPT_Load.tpt; tbuild -f /root/multiloadtest/TPT_Load.tpt; $ *Сбой 3706 синтаксическая ошибка: expected something between begin of request and the word ‘tbuild’. Statement# 2, Info =9 * Общее истекшее время было 1 секундой.

1 ответ

Получение кода ошибки ‘3706’. Выглядит как что-то с запятой в моем синтаксисе. Пытался максимально урезать код, все равно все равно все равно получаю ошибку. Мой SQL ниже. Использование Teradata так же. Есть идеи? Спасибо за помощь. SELECT work_order_number, sub_type_level_2, reporting_region.

Я взял запрос мой который был на суточном уровне и попытался преобразовать его в еженедельный с помощью функции TD_WEEK_OF_CALENDAR и вроде бы сделал всякие вещи перестают работать и я не совсем могу в этом разобраться. Вот базовый пример, обратите внимание я изменил запрос так что может.

tbuild — это TPT (Teradata Parallel Transporter) CLI, в той же манере bteq — это запрос CLI.
Вы выполняете его из командной строки, не из bteq .

Archives of the TeradataForum

Message Posted: Thu, 03 Nov 2011 @ 13:15:43 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Teradata Error 3706: expected something between

From:		Anomy Anom

<— Anonymously Posted: Wednesday, November 02, 2011 14:27 —>

Hi Folks,

I am getting a 3706 error while executing the below sql. Can anyone please help where I might be going wrong. Thanks much.

Error: 3706 Syntax error: expected something between ‘(‘ and the ‘current_date’ keyword.

     SELECT
     HSP_TRANSACTIONS.TX_ID,
     MAX(CASE WHEN CLR_DEP.DEPT_ABBREVIATION IS NOT NULL THEN
     SUBSTR(CLR_DEP.DEPT_ABBREVIATION,1,3)
     ELSE SUBSTR(CLR_DEP_ADM.DEPT_ABBREVIATION,1,3) END ) AS Facility,
     MAX(CLR_EAP.PROC_CODE) AS EAP_#,
     MAX(CASE WHEN CLR_DEP.DEPT_ABBREVIATION IS NOT NULL THEN
     SUBSTR(CLR_DEP.DEPT_ABBREVIATION,4,3)
     ELSE SUBSTR(CLR_DEP_ADM.DEPT_ABBREVIATION,4,3) END ) AS Dept FROM PRODB.HSP_TRANSACTIONS
     HSP_TRANSACTIONS LEFT OUTER JOIN PRODB.HSP_ACCOUNT HSP_ACCOUNT ON
     HSP_TRANSACTIONS.HSP_ACCOUNT_ID = HSP_ACCOUNT.HSP_ACCOUNT_ID LEFT OUTER JOIN
     kpbinc_pbhb.hsp_account_lob HSP_ACCOUNT_LOB ON HSP_ACCOUNT.HSP_ACCOUNT_ID =
     HSP_ACCOUNT_LOB.HSP_ACCOUNT_ID LEFT OUTER JOIN KPBINC_PBHB.LN_OF_BSNS LN_OF_BSNS ON
     HSP_ACCOUNT_LOB.LOB_ID=LN_OF_BSNS.LOB_ID
     LEFT OUTER JOIN PRODB.CLR_EAP CLR_EAP
     ON HSP_TRANSACTIONS.PROC_ID = CLR_EAP.PROC_ID LEFT OUTER JOIN PRODB.CLR_LOC CLR_LOC ON
     HSP_ACCOUNT.LOC_ID = CLR_LOC.LOC_ID  LEFT OUTER JOIN PRODB.ZC_LOC_RPT_GRP_7
     ZC_LOC_RPT_GRP_7 ON CLR_LOC.RPT_GRP_SEVEN = ZC_LOC_RPT_GRP_7.RPT_GRP_SEVEN LEFT OUTER
     JOIN PRODB.CLR_DEP CLR_DEP ON HSP_TRANSACTIONS.DEPARTMENT = CLR_DEP.DEPARTMENT_ID LEFT
     OUTER JOIN PRODB.PAT_ENC_HSP PAT_ENC_HSP ON PAT_ENC_HSP.HSP_ACCOUNT_ID =
     HSP_ACCOUNT.HSP_ACCOUNT_ID LEFT OUTER JOIN PRODB.CLR_DEP CLR_DEP_adm ON
     PAT_ENC_HSP.DEPARTMENT_ID = CLR_DEP_adm.DEPARTMENT_ID WHERE HSP_TRANSACTIONS.TX_POST_DATE
     >= case when 'Last Full Month' = 'Last Full Month' then add_months(current_date, -1)
     - dayofmonth(current_date) +1
     when 'Last Full Month' = 'Last Full Week' Then current_date -
     dayofweek(current_date) -6
     else CAST('2011-10-01' AS DATE FORMAT 'YYYY-MM-DD') end  AND
     HSP_TRANSACTIONS.TX_TYPE_HA_C = 1 AND CLR_EAP.PROC_CODE NOT IN ( '4007', '4008', '4009')
     GROUP BY 1


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Источник

I get below error.Does anyone know how to resolve?
*** Failure 3706 Syntax error: Data Type «»xyz»» does not match a Defin
ed Type name.
CREATE VOLATILE TABLE vt_cncl_ord AS
(
SELECT
(case when length(xyz) = 9 then xyz || ‘ ‘ else
(case when length(xyz) = 8 then xyz || ‘ ‘ else xyz end)end)end) as xyz,
FROM
vt_cncl_ord_1
)
WITH DATA
PRIMARY INDEX (xyz)
ON COMMIT PRESERVE ROWS
;

Read these next…

Green Brand Rep Wrap-Up: January 2023

Spiceworks Originals

Hi, y’all — Chad here. A while back, we used to feature the top posts from our brand reps (aka “Green Gals/Guys/et. al.) in a weekly or monthly wrap-up post. I can’t specifically recall which, as that was approximately eleven timelines ago. Luckily, our t…
Help with domain controller setup

Windows

I just got a new job as the only IT person for a business with around 270 employees (I would say probably less than half use computers) They don’t have any policies or procedures when it comes to IT, as they have never had an IT person. My background cons…
Malicious URLs

Security

We have firewall, we have endpoint protection, we have Safe links and Attachments for Office 365 (Microsoft Defense for Office 365 Plan 1), and still receiving links that lead to malicious web sites.It seems like security companies still didn’t develop a …
Snap! — Old Batteries, Lovable Bots, Quantum Breakthrough, Should We Trust AI?

Spiceworks Originals

Your daily dose of tech news, in brief.

Welcome to the Snap!

Flashback: February 8, 1996: The massive Internet collaboration “24 Hours in Cyberspace” takes place (Read more HERE.)

Bonus Flashback: February 8, 1974: Americans end outer spa…
Large collection of Mac Minis

Best Practices & General IT

We are getting rid of a lot of older equipment that doesn’t have a purpose anymore on our campus. Most of it is 2010 and 2014 Mac Minis. When they were purchased, they were the absolute base model, so nothing special about them. I’ve reached out to multip…

Источник

Hi all,

DB: Teradata
Problem: Trying to use Query fixture with query that contains timestamp constant as filter in Where clause. Got Java exception: [Error 3706] [SQLState 42000] Syntax error: Invalid TimeStamp Literal.
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:308)

Way to reproduce

|Execute Ddl|CREATE MULTISET TABLE dftest.Td_timestamp (id number, ts timestamp) NO PRIMARY INDEX|

!|Insert|dftest.Td_timestamp|
|id|ts|
|1|2014-09-25 16:26:11|
|2|2014-09-23 16:25:10|

!|Inspect query|SELECT id, ts FROM dftest.Td_timestamp|

!|Query|SELECT id FROM dftest.Td_timestamp|
|id|
|1|
|2|

!|Query|SELECT id, ts FROM dftest.Td_timestamp where id=1|
|id|ts|
|1|2014-09-25 16:26:11|

!|Query|SELECT id, ts FROM dftest.Td_timestamp where ts > TIMESTAMP '2014-01-01 00:00:00'|
|id|ts|
|1|2014-09-25 16:26:11|
|2|2014-09-23 16:25:10|

!|Execute Ddl|DROP TABLE dftest.Td_timestamp|

And here is Insert Query output:

Inspect query   SELECT id, ts FROM dftest.Td_timestamp
 id      ts
 1   2014-09-25 16:26:11.0
 2   2014-09-23 16:25:10.0

Test goes in following way:
Insert done, first and second Query fixtures shows success, but when it comes to last Query fixture it show exception:

java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.05] [Error 3706] [SQLState 42000] Syntax error: Invalid TimeStamp Literal.
    at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:308)
    at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:109)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:307)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:196)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:123)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:114)
    at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:386)
etc.

Removing centiseconds (.0) or modifying precision doesn’t help.
The very same query executed directly from bteq of Teradata SQL Assistant with default settings work fine.

Workaround
It works if firstly set up a parameter with value of TIMESTAMP ‘2014-01-01 00:00:00’ and then use this parameter in Query fixture.

Источник

Ошибка Failure 3706 Syntax error: expected something between начало запроса и слово ‘tbuild’

1 ответ

Похожие вопросы:

Archives of the TeradataForum

Message Posted: Thu, 03 Nov 2011 @ 13:15:43 GMT

Read these next…

Green Brand Rep Wrap-Up: January 2023

Help with domain controller setup

Malicious URLs

Snap! — Old Batteries, Lovable Bots, Quantum Breakthrough, Should We Trust AI?

Large collection of Mac Minis