3 Replies Latest reply on Apr 29, 2014 10:13 AM by Steven Hawkins

    Limit on the number of rows returned by file translator

    Rakesh Balguri Expert



      I am having a text file with around 138000 rows and I was trying to retrieve all the data from the  text file.

      What I noticed that only 47429 rows are returned and also the count(*) also returns the same number of rows


      I am using the getTextFiles() stored procedure and the TEXTTABLE().

      I am using teiid8.7


      Is there a limitation on the number of rows returned by the file translator?