[JBoss JIRA] (TEIID-3849) Writes using Cassandra connector are very slow
by Pranav K (JIRA)
Pranav K created TEIID-3849:
-------------------------------
Summary: Writes using Cassandra connector are very slow
Key: TEIID-3849
URL: https://issues.jboss.org/browse/TEIID-3849
Project: Teiid
Issue Type: Enhancement
Components: Misc. Connectors
Reporter: Pranav K
Assignee: Steven Hawkins
The connector seems to execute the insert queries one by one rather than using batched approach, also the API used is the synchronous one instead of the future based async API [session.executeAsync()]
Cassandra writes are generally very fast, but it was noted in one scenario that on a single node Cassandra setup inserting a set 50k records and 3 columns took more than 25 mins.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3848) Issue with hive literal timestamps
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3848?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3848.
-----------------------------------
Resolution: Done
Added an explicit cast which is supported by both impala and hive.
> Issue with hive literal timestamps
> ----------------------------------
>
> Key: TEIID-3848
> URL: https://issues.jboss.org/browse/TEIID-3848
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.11
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.13, 8.12.3
>
>
> With testing TEIID-3847 Hive 1.2.1 failed to compare appropriately with a timestamp string literal in the source sql containing .0 fractional seconds:
> t = '2000-01-01 12:00:00.0' -- did not work
> But the following does
> t = '2000-01-01 12:00:00'
> t = cast('2000-01-01 12:00:00.0' as timestamp)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3848) Issue with hive literal timestamps
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3848:
-------------------------------------
Summary: Issue with hive literal timestamps
Key: TEIID-3848
URL: https://issues.jboss.org/browse/TEIID-3848
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.11
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.13, 8.12.3
With testing TEIID-3847 Hive 1.2.1 failed to compare appropriately with a timestamp string literal in the source sql containing .0 fractional seconds:
t = '2000-01-01 12:00:00.0' -- did not work
But the following does
t = '2000-01-01 12:00:00'
t = cast('2000-01-01 12:00:00.0' as timestamp)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month