Hi,
The query
select * from table_name partition (#prompt('part_name')#) [/i]
generates error during validation.
Any idea how to pass partition name to sql query? I have a very large table and it is partitioned by day (over 2 mln records) . I can use where in query , but partition is much faster.
Regards