[
https://issues.apache.org/jira/browse/DRILL-7767?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Swatantra Agrawal updated DRILL-7767:
-------------------------------------
Description:
Drill does not honour these flags when dealing with ISODate.
{noformat}
store.mongo.all_text_mode
drill.exec.functions.cast_empty_string_to_null
{noformat}
Steps to Reproduce:
Set both the properties to true or exclusively set to true.
Insert 2 records in a collection as below
{noformat}
db.temp.save({reportDate:ISODate()});
db.temp.save({reportDate:""});
{noformat}
Execute Query
{noformat}
SELECT reportDate from mongo.drill.temp
{noformat}
An Exception is thrown
{noformat}
org.apache.drill.common.exceptions.UserRemoteException: INTERNAL_ERROR ERROR:
You tried to write a VarChar type when you are using a ValueWriter of type
NullableTimeStampWriterImpl.{noformat}
was:
Drill does not honour these flags when dealing with ISODate.
{noformat}
store.mongo.all_text_mode
drill.exec.functions.cast_empty_string_to_null
{noformat}
Steps to Reproduce:
Set both the properties to true.
Insert 2 records in a collection as below
{noformat}
db.temp.save({reportDate:ISODate()});
db.temp.save({reportDate:""});
{noformat}
Execute Query
{noformat}
SELECT reportDate from mongo.drill.temp
{noformat}
An Exception is thrown
{noformat}
org.apache.drill.common.exceptions.UserRemoteException: INTERNAL_ERROR ERROR:
You tried to write a VarChar type when you are using a ValueWriter of type
NullableTimeStampWriterImpl.{noformat}
> When fetching Timestamp all text mode and empty to null not honoured
> --------------------------------------------------------------------
>
> Key: DRILL-7767
> URL: https://issues.apache.org/jira/browse/DRILL-7767
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - MongoDB
> Affects Versions: 1.17.0
> Reporter: Swatantra Agrawal
> Priority: Major
>
> Drill does not honour these flags when dealing with ISODate.
> {noformat}
> store.mongo.all_text_mode
> drill.exec.functions.cast_empty_string_to_null
> {noformat}
>
> Steps to Reproduce:
> Set both the properties to true or exclusively set to true.
> Insert 2 records in a collection as below
> {noformat}
> db.temp.save({reportDate:ISODate()});
> db.temp.save({reportDate:""});
> {noformat}
>
> Execute Query
> {noformat}
> SELECT reportDate from mongo.drill.temp
> {noformat}
>
> An Exception is thrown
> {noformat}
> org.apache.drill.common.exceptions.UserRemoteException: INTERNAL_ERROR ERROR:
> You tried to write a VarChar type when you are using a ValueWriter of type
> NullableTimeStampWriterImpl.{noformat}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
