Query returned no results message

Question

Query returned no results message

Sarhan, Amr 0

DROP TABLE IF EXISTS userdb_sarhan_aa.UPI_Weekly_Analysis_FY24;
CREATE TABLE userdb_sarhan_aa.UPI_Weekly_Analysis_FY24 as
SELECT calendar_year_week,calendar_date, material, plant, BUoM_Total_Plant_Stock_T
,BUoM_Red_R,BUoM_Orange_O,BUoM_Amber_M,BUoM_SND_Excess_D,BUoM_Launch_Excess_L,BUoM_Excess_Y
FROM ap_inventory.inventory_fct_emea
WHERE calday > 20230700 AND calday < 20240700 
AND region = "EUE"
;

1 answer

Your answer

Answer 1

Michael Taylor 60,326

We have no visibility into your database so we have no way of confirming what is wrong here. You need to diagnose this yourself. Start with the simplest query.

SELECT * FROM ap_inventory.inventory_fct_emea

Do you get results back? If so then add your conditions one by one. I'd start with region = 'EUE'. Notice that the string is in single quotes, not double quotes. Did you get any data back? If not then check your table and confirm there are any rows with a region of EUE. Note that depending upon your database there could be empty spaces on either side or other things causing the condition to be false. Check all that out.

If the above query works then add in your final condition. Note that we have no idea what type calday is. If it is an integral value then, again, check the table to see if you have any rows that match. If the column is a date/datetime then the integral conversion probably isn't right, use a date literal instead. Also consider using BETWEEN instead of the relational operators but note that it is inclusive so your original relation would be something like calday BETWEEN 20230701 AND 20240630 I'm thinking.

Sarhan, Amr 0 Reputation points

2024-01-25T08:52:54.3833333+00:00
so the calday type is int and when I use the following query:
I get the result attached as a photo

select * from ap_inventory.inventory_fct_emea where calday > 20230700 and calday < 20240700 and region = 'EUE' limit 10
Michael Taylor 60,326 Reputation points

2024-01-25T14:52:50.72+00:00

Ok, so when you said the query returned no results maybe you should clarify. The actual SQL code you gave will return no results because you're not actually querying any data. Your query is creating a table and inserting the results of a query into that table. Hence the execution of the original code you gave returns no results. However the table should have the expected data in it. You should be able to select * from userdb_sarhan_aa.UPI_Weekly_Analysis_FY24 and see what was inserted. Can you confirm that the new table you created is empty?

Also be aware that you're limiting the results of the query to 10 in your test but the actual table query is pulling all of it. As a result if some of your data is incorrect then the query will fail but you wouldn't see that in your test because you aren't looking at all the rows.

Share via

Query returned no results message

1 answer

Your answer