MetaMatrix Text File Connector hangs when using a large data file

Solution Verified - Updated -

Issue

  • We have created a model for a text file data source and the text file has 90,000 records and 98 columns.
  • I ran the query in the MetaMatrix Designer and it is taking forever to return results from this file. If I use a LIMIT 16000 clause, it returns 16000 records.  But if I add even 16001,  it is not returning results and keeps running so I have to cancel the query.

Environment

  • MetaMatrix Enterprise Server 5.5.4
  • MetaMatrix Enterprise Designer 5.5.4
  • MetaMatrix Text File Connector 5.5.4

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content