Toad Data Point Import Data takes a very long time on Hive ODBC connection. (4302660)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Toad Data Point Import Data takes a very long time on Hive ODBC connection.
Description

TDP Import Data takes a very long time on Hive ODBC connection.
When user does an Import Wizard from a CSV file, it is very slow. Also, each row imported gives the message:

MESSAGE:
"insert into ccbpoc.test_import ('date','open','high','low','close','adjclose','volume') ...
Rows affected: -1"

User can check-mark the box, 'Do not prompt me again', but that message is still shown on the Output Window and each imported row still takes about 8 seconds each, so it is very slow.
Cause

Import Data on Hive connections are not supported.
Resolution

Import Data on Hive connections are not supported. Import Data on Hive direct connection is currently disabled. A change request has been created to disable it as well on Hive ODBC connections.
Defect ID

QAT-13181

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title