Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I got the error bellow :
Champ introuvable - <period_id>
SELECT * FROM "GPPROD".p_edxxxll_index
left join "GPxxxxl_id
where assignment_type_id = 18
AND period_id >= 201601
and period_id <= '201710'
When i execute the query in green plume, it works perfectly :
Thank you
May be Add SQL Select ....
the same error :
Champ introuvable - <period_id>
sql SELECT * FROM "GPPROD".xxxx
...
Please check that period_id column is present or not in that table...
yes. it is here is my script:
LOAD
period_id,
cell_id,
cell_site_id as site_id,
cell_name,
cell_manufacturer,
cell_technology,
total_revenu as Total_revenu,
data_revenu as Data_revenu,
voice_revenu as Voice_revenu,
weekend_revenu,
weekend_data_revenu,
weekend_voice_revenu,
voice_off_peack_revenu as Voice_off_peack_revenu,
voice_off_peack_data_revenu as Voice_off_peack_data_revenu,
voice_off_peack_voice_revenu as Voice_off_peack_voice_revenu,
data_off_peack_revenu as Data_off_peack_revenu,
data_off_peack_data_revenu as Data_off_peack_data_revenu,
data_off_peack_voice_revenu as Data_off_peack_voice_revenu,
voice_on_peack_revenu as Voice_on_peack_revenu,
voice_on_peack_data_revenu as Voice_on_peack_data_revenu,
voice_on_peack_voice_revenu as Voice_on_peack_voice_revenu,
data_on_peack_revenu as Data_on_peack_revenu,
data_on_peack_data_revenu as Data_on_peack_data_revenu,
data_on_peack_voice_revenu as Data_on_peack_voice_revenu
;
sql SELECT * FROM "Gxxxndex
left join "GPxxxndex.cell_id
where assignment_type_id = 18
AND period_id >= 201601
and period_id <= 201710;
exit script ;
Try to give alias for table and try
sql SELECT * FROM "Gxxxndex a
left join "GPxxxndex.cell_id b
where assignment_type_id = 18
AND a.period_id >= 201601
and a.period_id <= 201710;
Hi, could it be that you miss ON in Your left join?
sql SELECT * FROM "Gxxxndex a
left join "GPxxxndex.cell_id b ON
where assignment_type_id = 18
AND a.period_id >= 201601
and a.period_id <= 201710;
sql SELECT * FROM "Gxxxndex
left join "GPxxxndex.cell_id
where assignment_type_id = 18
AND period_id >= 201601
and period_id <= 201710;
...
Does Double quotes not closed anymore. May be the cause it throws error
To test, omit the Preceding LOAD or put it in comments. Then run the SQL statement on its own, and see what you get in the table viewer (Ctrl-T). DBMS that comply with the ANSI SQL standard may return field names in all upper case.