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

      Hi,

       

      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?

       

      Thanks

      Rakesh.