input tools to use - static input or indb input?

[becki]

is there a hard limit on records, from a static input (from hdfs/hadoop, if that matters)?  i tried to download an entire table with just a "select * from <blah>" and i get about 2,318,000 records.  (there is no "where" clause, it's just go get all) but if i do the same with indb, i get more like 5M records (aka, the whole thing).  I was hoping to use static input because the downstream tools are better but is the workaround for this issue (if it's an issue at all) to use indb, store the resulting table to an alteryx database, then open that?  how would i use a "block until" with an "indb input"?  thanks

becki kain

[KaneG]

Hi @becki,

There is no actual limit. If you are experiencing some funny timeout here, then you can try to connect In-DB and then Data-Stream Out.

[becki]

any idea how to do a block until with the in db read in?  thanks

[KaneG · Accepted solution]

There is no way to do a Block Until Done with In-DB tools. You would need to do it after streaming the data into memory.