HI, if I run this query:
select from `:/folder/trade/
(trade suppose to be a partition table with trade data )
And it get “length” error, anything I can do to further check what is the problem? Say which column have less element than other column?
q)`:db/2000.01.01/t/ set (a:til 10;b:til 10;c:til 10)
q)`:db/2000.01.01/t/c set til 5
q)select from `:db/2000.01.01/t
'length
[0] select from `:db/2000.01.01/t
^
q)count each :db/2000.01.01/t/ each get
:db/2000.01.01/t/.d
10 10 5
Thanks a lot Charles, it is very helpful