[DRILL-1836] Default length for Varchar in cast expressions should be changed

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Execution - Data Types
• Assignee: Unassigned
• Reporter: Abhishek Girish
• Created: 10/Dec/14 19:47
• Updated: 01/Oct/15 16:36

Description

Current behavior:

Specify length:
> select cast(t1.colfam1.col1 as varchar(10)) from table1 t1;
------------

EXPR$0

------------

val1

val21

val26

------------

Default length for varchar in a cast expression:
> select cast(t1.colfam1.col1 as varchar) from table1 t1;
------------

EXPR$0

------------

v

v

v

------------

When the length attribute is not specified with varchar, in a cast expression, Drill treats the default length to be 1.

Postgres and SQL Server sets the default length to be 30 in such a scenario. The behavior for Drill must be modified to something similar.