Hey, I am having an issue with the Fundamentals Capstone course (on Developer) with trying to obtain the unique option IDs from the trade table in part 1. I have loaded the trade table from the partitioned database using the table importer. I am using the following code but I am getting a par error - unable to operate on a partitioned table.
q code: uniqueOpts:distinct trade`option_id
Does anyone have any thoughts on how to answer this? Thanks
Thanks for sharing this with the community. Great content!
I believe the error generated is a result of your method for retrieving the unique OptionIDs. Given your table is partitioned, this method of taking columns from tables will not work . Hence the ‘unable to operate on a partitioned table’ error.
I suggest querying the table, meaning avail of Functional qSQL Statements as an alternate approach to obtain the unique OptionIDs from the trade table.
Create uniqueOpts by following the syntax below (provided in the previous link) where square brackets mark optional elements. This is what we refer to as ‘querying’ the table.
exec [distinct] ps [by pb] from texp [where pw]
The above code is a ‘hint’ and requires modification.