teradata insert command issue

Question

teradata insert command issue

gsai78 (IS/IT--Management)

(OP)

4 Sep 09 15:16

I am trying to insert data into one table in teradata from another and receiving syntax error msg.[3707] some operator expected between ')' and 'from'

can somebody help where am I going wrong -

here's query -
Insert into BI_DW.SSI_Calls2care
Values
(
select
dim_device_id
,date_yyyymm


,sum(call_cnt)
,sum(start_base)
,sum(end_base)
from call_join

group by 1,2,3
order by 1,2,3

whitestorm (TechnicalUser) · Answer 1 · 2009-11-05 12:47:44

Are there only 5 fields in SSI_Calls2care?
If yes,Try this:

Insert into BI_DW.SSI_Calls2care
select
dim_device_id
,date_yyyymm
,sum(call_cnt)
,sum(start_base)
,sum(end_base)
from call_join
group by 1,2;

tarunteradata (Programmer) · Answer 2 · 2009-12-23 19:04:58

You have not closed the parenthesis.
you have started writing the select statement inside parenthesis and did not closed it,so try by closing it.

Come Join Us!

Posting Guidelines

Jobs

teradata insert command issue