Getting error while running an sql script in ADW

Question

Am getting an error that goes like this:
Insert values statement can contain only constant literal values or variable references.

these are the statements in which I am getting the errors:

INSERT INTO val.summary_numbers (metric_name, metric_val, dt_create) VALUES ('Total IP Enconters',
                                                                             (SELECT
                                                                                count(DISTINCT encounter_id)
                                                                              FROM prod.encounter
                                                                              WHERE encounter_type = 'Inpatient')

                                                                             ,
                                                                                (SELECT min(mod_loadidentifier)
                                                                                 FROM ccsm.stg_demographics_baseline)

                                                                             );


INSERT INTO val.summary_numbers (metric_name, metric_val, dt_create) VALUES ('Total 30d Readmits',
                                                                  (SELECT
                                                                     count(DISTINCT encounter_id)
                                                                   FROM prod.encounter_attr
                                                                   WHERE
                                                                     attr_name = 'day_30_readmit' AND attr_value = 1)

                                                                  ,
                                                                     (SELECT min(mod_loadidentifier)
                                                                      FROM ccsm.stg_demographics_baseline));

GregGalloway · Accepted Answer · 2018-06-12 23:05:21Z

2

Change your query like this:

insert into val.summary_numbers
select
        'Total IP Enconters',
        (select  count(distinct encounter_id)
         from    prod.encounter
         where   encounter_type = 'Inpatient'),
        (select  min(mod_loadidentifier)
         from    ccsm.stg_demographics_baseline)

edited Jun 12, 2018 at 23:05

GregGalloway

11.6k3 gold badges21 silver badges48 bronze badges

answered Jun 12, 2018 at 9:44

Ron Dunn

3,09822 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dead Man Over a year ago

When am using the above am getting parsing error near from statement

GregGalloway Over a year ago

@DeadMan fixed a paren. Try again

Allan Miller · Accepted Answer · 2018-06-12 13:59:06Z

0

When using the ADW service, I would recommend that you consider using the CTAS operation possibly combined with a RENAME. The RENAME is a metadata operation so it is fast and the CTAS is parallel where the INSERT INTO will be row by row.

You may still have a data related issue that can be hard to determine with out the create table statement.

Thanks

answered Jun 12, 2018 at 13:59

Allan Miller

211 bronze badge

Collectives™ on Stack Overflow

Getting error while running an sql script in ADW

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related