[DRILL-4406] extract () Error: SYSTEM ERROR: ClassCastException. Caused By (java.lang.ClassCastException)

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.5.0
• Fix Version/s: 1.5.0
• Component/s: Storage - JDBC
• Assignee: Taras Supyk
• Reporter: N Campbell
• Created: 17/Feb/16 21:22
• Updated: 14/Mar/16 02:54

Description

Trying to extract( ) from a Postgres timestamp column fails

create table TTS ( RNUM integer not null , CTS timestamp(3 ) ) ;

Error: SYSTEM ERROR: ClassCastException

[Error Id: 4a6a1f6e-1caa-42c4-b44c-8db621477776 on centos1:31010]

(org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception during fragment initialization: null
org.apache.drill.exec.work.foreman.Foreman.run():261
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745
Caused By (java.lang.ClassCastException) null

SQLState: null
ErrorCode: 0