question Re: Speeding up : select "n" rows from a view (select * from view limit n) without any filter condition. in Support Questions

question Re: Speeding up : select "n" rows from a view (select * from view limit n) without any filter condition. in Support Questions https://community.cloudera.com/t5/Support-Questions/Speeding-up-select-quot-n-quot-rows-from-a-view-select-from/m-p/226046#M187907 <P>What does the query look like in the "db.view"? How many joins, formats of underlying table, where clauses etc. If you're just doing a straight "select * from table limit 10" I'd expect it to return almost immediately but any kind of processing will take a few seconds. Have you tried LLAP/Interactive Queries?</P> Wed, 23 Aug 2017 00:40:24 GMT sweeks 2017-08-23T00:40:24Z