Encounter an exception: Query would require a scan without a limit on table(s)


#1

Hi Mapd experts,

I have a table with 30M rows generated by TPC-H dbgen tool, now I perform an sql script:
select * from LINEITEM order by L_SUPPKEY limit 10;
And I got an exception:
Exception: Query would require a scan without a limit on table(s): LINEITEM
What is the possible reason of this exception?

Thanks,
Mike


#2

Hi

Thanks for looking into MapD.

Please see

And

https://github.com/mapd/mapd-core/issues/19

Regards