[jira] [Commented] (DRILL-4996) Parquet Date auto-correction is not working in auto-partitioned parquet files generated by drill-1.6

2016-11-07 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15644726#comment-15644726 ] Vitalii Diravka commented on DRILL-4996: Interesting that we found the case when an old version of

[jira] [Updated] (DRILL-4373) Drill and Hive have incompatible timestamp representations in parquet

2016-10-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-4373: --- Description: git.commit.id.abbrev=83d460c I created a parquet file with a timestamp type

[jira] [Updated] (DRILL-4203) Parquet File : Date is stored wrongly

2016-10-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-4203: --- Description: Hello, I have some problems when i try to read parquet files produce by drill

[jira] [Resolved] (DRILL-4342) Drill fails to read a date column from hive generated parquet

2016-10-19 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka resolved DRILL-4342. Resolution: Duplicate > Drill fails to read a date column from hive generated parquet >

[jira] [Commented] (DRILL-5034) Select timestamp from hive generated parquet always return in UTC

2016-11-11 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15657706#comment-15657706 ] Vitalii Diravka commented on DRILL-5034: As for me it is not a bug. Accordingly to the [spec

[jira] [Commented] (DRILL-4373) Drill and Hive have incompatible timestamp representations in parquet

2016-11-11 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15657809#comment-15657809 ] Vitalii Diravka commented on DRILL-4373: The known

[jira] [Commented] (DRILL-5034) Select timestamp from hive generated parquet always return in UTC

2016-11-14 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15664294#comment-15664294 ] Vitalii Diravka commented on DRILL-5034: Everything is right but I want to clarify N3 case: - If

[jira] [Assigned] (DRILL-4980) Upgrading of the approach of parquet date correctness status detection

2016-11-24 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-4980: -- Assignee: Vitalii Diravka (was: Parth Chandra) > Upgrading of the approach of parquet

[jira] [Commented] (DRILL-5034) Select timestamp from hive generated parquet always return in UTC

2016-11-24 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15692834#comment-15692834 ] Vitalii Diravka commented on DRILL-5034: No, it doesn't. Because drill doesn't generate timestamp

[jira] [Updated] (DRILL-4980) Upgrading of the approach of parquet date correctness status detection

2016-11-24 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-4980: --- Affects Version/s: (was: 1.8.0) 1.9.0 Fix Version/s:

[jira] [Commented] (DRILL-5034) Select timestamp from hive generated parquet always return in UTC

2016-11-16 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670906#comment-15670906 ] Vitalii Diravka commented on DRILL-5034: Note: It is no way to determine the value of the

[jira] [Commented] (DRILL-4874) "No UserGroupInformation while generating ORC splits" - hive known issue in 1.2.0-mapr-1607 release.

2016-11-19 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15679077#comment-15679077 ] Vitalii Diravka commented on DRILL-4874: This is the hive issue, which described here

[jira] [Commented] (DRILL-5004) Parquet date correction gives null pointer exception if there is no createdBy entry in the metadata

2016-11-04 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15637233#comment-15637233 ] Vitalii Diravka commented on DRILL-5004: [~Parth] Could you please provide a file? > Parquet date

[jira] [Comment Edited] (DRILL-5004) Parquet date correction gives null pointer exception if there is no createdBy entry in the metadata

2016-11-04 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15637233#comment-15637233 ] Vitalii Diravka edited comment on DRILL-5004 at 11/4/16 6:19 PM: -

[jira] [Commented] (DRILL-4996) Parquet Date auto-correction is not working in auto-partitioned parquet files generated by drill-1.6

2016-12-08 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15732970#comment-15732970 ] Vitalii Diravka commented on DRILL-4996: Yes, I meant exactly this. In the result we will

[jira] [Comment Edited] (DRILL-4996) Parquet Date auto-correction is not working in auto-partitioned parquet files generated by drill-1.6

2016-12-08 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15645729#comment-15645729 ] Vitalii Diravka edited comment on DRILL-4996 at 12/8/16 6:04 PM: - Right.

[jira] [Comment Edited] (DRILL-4996) Parquet Date auto-correction is not working in auto-partitioned parquet files generated by drill-1.6

2016-12-08 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15645729#comment-15645729 ] Vitalii Diravka edited comment on DRILL-4996 at 12/8/16 6:04 PM: - Right.

[jira] [Comment Edited] (DRILL-4996) Parquet Date auto-correction is not working in auto-partitioned parquet files generated by drill-1.6

2016-12-08 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15645729#comment-15645729 ] Vitalii Diravka edited comment on DRILL-4996 at 12/8/16 6:04 PM: - Right.

[jira] [Updated] (DRILL-5097) Using store.parquet.reader.int96_as_timestamp gives IOOB whereas convert_from works

2016-12-14 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5097: --- Component/s: (was: Execution - Codegen) Storage - Parquet

[jira] [Updated] (DRILL-5097) Using store.parquet.reader.int96_as_timestamp gives IOOB whereas convert_from works

2016-12-14 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5097: --- Labels: (was: FreeMarker TimestampVector) > Using store.parquet.reader.int96_as_timestamp

[jira] [Updated] (DRILL-5097) Using store.parquet.reader.int96_as_timestamp gives IOOB whereas convert_from works

2016-12-14 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5097: --- Description: Using store.parquet.reader.int96_as_timestamp gives IOOB whereas convert_from

[jira] [Commented] (DRILL-5002) Using hive's date functions on top of date column in parquet gives wrong results

2016-12-13 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15745418#comment-15745418 ] Vitalii Diravka commented on DRILL-5002: [~rkins] I tried to use some hive functions with

[jira] [Commented] (DRILL-5002) Using hive's date functions on top of date column in parquet gives wrong results

2016-12-12 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15742842#comment-15742842 ] Vitalii Diravka commented on DRILL-5002: [~rkins] I tested these functions with hive plugin and

[jira] [Comment Edited] (DRILL-5002) Using hive's date functions on top of date column in parquet gives wrong results

2016-12-12 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15742842#comment-15742842 ] Vitalii Diravka edited comment on DRILL-5002 at 12/12/16 7:22 PM: --

[jira] [Updated] (DRILL-5097) Need to change the default width of the timestamp vector

2016-12-02 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5097: --- Attachment: data.snappy.parquet > Need to change the default width of the timestamp vector >

[jira] [Created] (DRILL-5097) Need to change the default width of the timestamp vector

2016-12-02 Thread Vitalii Diravka (JIRA)
Vitalii Diravka created DRILL-5097: -- Summary: Need to change the default width of the timestamp vector Key: DRILL-5097 URL: https://issues.apache.org/jira/browse/DRILL-5097 Project: Apache Drill

[jira] [Commented] (DRILL-3510) Add ANSI_QUOTES option so that Drill's SQL Parser will recognize ANSI_SQL identifiers

2016-12-27 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15780561#comment-15780561 ] Vitalii Diravka commented on DRILL-3510: Adding ANSI_QUOTES option will allow to use [MYSQL_ANSI |

[jira] [Closed] (DRILL-5002) Using hive's date functions on top of date column in parquet gives wrong results

2016-12-19 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka closed DRILL-5002. -- Resolution: Won't Fix Since DRILL-4203 was fixed, changes for this ticket are not required. >

[jira] [Created] (DRILL-5373) Drill JDBC error in the process of connection via SQuirrel: java.lang.NoClassDefFoundError: javax/validation/constraints/NotNull

2017-03-21 Thread Vitalii Diravka (JIRA)
Vitalii Diravka created DRILL-5373: -- Summary: Drill JDBC error in the process of connection via SQuirrel: java.lang.NoClassDefFoundError: javax/validation/constraints/NotNull Key: DRILL-5373 URL:

[jira] [Commented] (DRILL-4971) query encounters system error: Statement "break AndOP3" is not enclosed by a breakable statement with label "AndOP3"

2017-03-22 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15936671#comment-15936671 ] Vitalii Diravka commented on DRILL-4971: Braces near the "AndOP" label are absent for "booleanAND"

[jira] [Updated] (DRILL-4971) Query encounters system error, when there aren't eval subexpressions of any function in boolean and/or expressions

2017-03-24 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-4971: --- Summary: Query encounters system error, when there aren't eval subexpressions of any function

[jira] [Commented] (DRILL-5377) Drill returns weird characters when parquet date auto-correction is turned off

2017-03-28 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15945457#comment-15945457 ] Vitalii Diravka commented on DRILL-5377: sqlline usually cuts a years longer than . In the

[jira] [Created] (DRILL-5402) ServerMeta should be updated during the session, if the last has been changed.

2017-03-30 Thread Vitalii Diravka (JIRA)
Vitalii Diravka created DRILL-5402: -- Summary: ServerMeta should be updated during the session, if the last has been changed. Key: DRILL-5402 URL: https://issues.apache.org/jira/browse/DRILL-5402

[jira] [Comment Edited] (DRILL-4980) Upgrading of the approach of parquet date correctness status detection

2017-03-29 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15946915#comment-15946915 ] Vitalii Diravka edited comment on DRILL-4980 at 3/29/17 10:49 AM: --

[jira] [Commented] (DRILL-4203) Parquet File : Date is stored wrongly

2017-03-27 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15943304#comment-15943304 ] Vitalii Diravka commented on DRILL-4203: [~rkins] You may also add an extra cases for testing: 1.

[jira] [Commented] (DRILL-5002) Using hive's date functions on top of date column gives wrong results for local time-zone

2017-03-15 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15926115#comment-15926115 ] Vitalii Diravka commented on DRILL-5002: The issue is related to the hive built-in functions with

[jira] [Commented] (DRILL-5363) CURRENT_TIMESTAMP() documented, but not actually available in Drill

2017-03-17 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15929808#comment-15929808 ] Vitalii Diravka commented on DRILL-5363: [~paul-rogers] I found from the

[jira] [Commented] (DRILL-5373) Drill JDBC error in the process of connection via SQuirrel: java.lang.NoClassDefFoundError: javax/validation/constraints/NotNull

2017-03-21 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15935201#comment-15935201 ] Vitalii Diravka commented on DRILL-5373: PR with commit for this issue:

[jira] [Commented] (DRILL-5377) Drill returns weird characters when parquet date auto-correction is turned off

2017-04-05 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15957116#comment-15957116 ] Vitalii Diravka commented on DRILL-5377: [~rkins] Could you verify above usecase? > Drill returns

[jira] [Created] (DRILL-5413) DrillConnectionImpl.isReadOnly() throws NullPointerException

2017-04-05 Thread Vitalii Diravka (JIRA)
Vitalii Diravka created DRILL-5413: -- Summary: DrillConnectionImpl.isReadOnly() throws NullPointerException Key: DRILL-5413 URL: https://issues.apache.org/jira/browse/DRILL-5413 Project: Apache Drill

[jira] [Updated] (DRILL-5213) Prepared statement for actual query is missing the query text

2017-04-11 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5213: --- Attachment: sorting_issue.png issue.png fix.png > Prepared

[jira] [Commented] (DRILL-5213) Prepared statement for actual query is missing the query text

2017-04-11 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15964281#comment-15964281 ] Vitalii Diravka commented on DRILL-5213: In the process of solving this task the issue of sorting

[jira] [Updated] (DRILL-5326) Unit tests failures related to the SERVER_METADTA

2017-03-07 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5326: --- Description: 1. In DRILL-5301 a new SERVER_META rpc call was introduced. The server will

[jira] [Updated] (DRILL-5326) Unit tests failures related to the SERVER_METADTA

2017-03-07 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5326: --- Summary: Unit tests failures related to the SERVER_METADTA (was: Unexpected/unhandled

[jira] [Updated] (DRILL-5326) Unit tests failures related to the SERVER_METADTA

2017-03-07 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5326: --- Description: 1. In DRILL-5301 a new SERVER_META rpc call was introduced. The server will

[jira] [Commented] (DRILL-5002) Using hive's date functions on top of date column gives wrong results for local time-zone

2017-03-14 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15924387#comment-15924387 ] Vitalii Diravka commented on DRILL-5002: It seems that if the DRILL-5332 is solved, this issue

[jira] [Assigned] (DRILL-5334) Questionable code in the TimeVector class

2017-03-14 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-5334: -- Assignee: Vitalii Diravka > Questionable code in the TimeVector class >

[jira] [Assigned] (DRILL-5332) DateVector support uses questionable conversions to a time

2017-03-14 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-5332: -- Assignee: Vitalii Diravka > DateVector support uses questionable conversions to a time

[jira] [Resolved] (DRILL-4203) Parquet File : Date is stored wrongly

2017-03-03 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka resolved DRILL-4203. Resolution: Fixed This is resolved since: 1.

[jira] [Updated] (DRILL-4203) Parquet File : Date is stored wrongly

2017-03-03 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-4203: --- Description: Hello, I have some problems when i try to read parquet files produce by drill

[jira] [Resolved] (DRILL-4373) Drill and Hive have incompatible timestamp representations in parquet

2017-03-03 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka resolved DRILL-4373. Resolution: Fixed Fix Version/s: 1.10.0 This is resolved since

[jira] [Commented] (DRILL-5326) Unit tests failures related to the SERVER_METADTA

2017-03-07 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15900411#comment-15900411 ] Vitalii Diravka commented on DRILL-5326: Example of the row order sorting with nulls: {code} 0:

[jira] [Created] (DRILL-5326) Unexpected/unhandled MinorType value GENERIC_OBJECT

2017-03-07 Thread Vitalii Diravka (JIRA)
Vitalii Diravka created DRILL-5326: -- Summary: Unexpected/unhandled MinorType value GENERIC_OBJECT Key: DRILL-5326 URL: https://issues.apache.org/jira/browse/DRILL-5326 Project: Apache Drill

[jira] [Commented] (DRILL-5213) Prepared statement for actual query is missing the query text

2017-04-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15972471#comment-15972471 ] Vitalii Diravka commented on DRILL-5213: Fixed in commit dfb5f4bb. > Prepared statement for

[jira] [Updated] (DRILL-3510) Add ANSI_QUOTES option so that Drill's SQL Parser will recognize ANSI_SQL identifiers

2017-07-31 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-3510: --- Description: Currently Drill's SQL parser uses backtick as identifier quotes, the same as

[jira] [Updated] (DRILL-3510) Add ANSI_QUOTES option so that Drill's SQL Parser will recognize ANSI_SQL identifiers

2017-07-31 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-3510: --- Description: *Added a possibility of changing characters for quoting identifiers by setting

[jira] [Updated] (DRILL-3510) Add ANSI_QUOTES option so that Drill's SQL Parser will recognize ANSI_SQL identifiers

2017-07-31 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-3510: --- Description: Currently Drill's SQL parser uses backtick as identifier quotes, the same as

[jira] [Updated] (DRILL-3510) Add ANSI_QUOTES option so that Drill's SQL Parser will recognize ANSI_SQL identifiers

2017-07-31 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-3510: --- Description: Currently Drill's SQL parser uses backtick as identifier quotes, the same as

[jira] [Updated] (DRILL-3510) Add ANSI_QUOTES option so that Drill's SQL Parser will recognize ANSI_SQL identifiers

2017-07-31 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-3510: --- Description: Currently Drill's SQL parser uses backtick as identifier quotes, the same as

[jira] [Updated] (DRILL-3510) Add ANSI_QUOTES option so that Drill's SQL Parser will recognize ANSI_SQL identifiers

2017-07-31 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-3510: --- Description: *Added a possibility of changing characters for quoting identifiers by setting

[jira] [Resolved] (DRILL-3829) Metadata Caching : Drill should ignore a corrupted cache file

2017-08-16 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka resolved DRILL-3829. Resolution: Fixed Fix Version/s: (was: Future) 1.12.0 Fixed

[jira] [Resolved] (DRILL-3827) Empty metadata file causes queries on the table to fail

2017-08-16 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka resolved DRILL-3827. Resolution: Fixed Fix Version/s: (was: Future) 1.12.0 Fixed

[jira] [Updated] (DRILL-3867) Store relative paths in metadata file

2017-08-11 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-3867: --- Description: git.commit.id.abbrev=cf4f745 git.commit.time=29.09.2015 @ 23\:19\:52 UTC The

[jira] [Assigned] (DRILL-3829) Metadata Caching : Drill should ignore a corrupted cache file

2017-08-09 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-3829: -- Assignee: Vitalii Diravka > Metadata Caching : Drill should ignore a corrupted cache

[jira] [Assigned] (DRILL-3827) Empty metadata file causes queries on the table to fail

2017-08-09 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-3827: -- Assignee: Vitalii Diravka (was: Parth Chandra) > Empty metadata file causes queries

[jira] [Comment Edited] (DRILL-5660) Drill 1.10 queries fail due to Parquet Metadata "corruption" from DRILL-3867

2017-07-13 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16082118#comment-16082118 ] Vitalii Diravka edited comment on DRILL-5660 at 7/13/17 7:01 PM: -

[jira] [Commented] (DRILL-5660) Drill 1.10 queries fail due to Parquet Metadata "corruption" from DRILL-3867

2017-07-13 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086292#comment-16086292 ] Vitalii Diravka commented on DRILL-5660: [~paul-rogers], [~jni] The patch is submitted. And the

[jira] [Commented] (DRILL-5660) Drill 1.10 queries fail due to Parquet Metadata "corruption" from DRILL-3867

2017-07-11 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16082118#comment-16082118 ] Vitalii Diravka commented on DRILL-5660: [~paul-rogers] I agree with update the metadata file

[jira] [Comment Edited] (DRILL-5660) Drill 1.10 queries fail due to Parquet Metadata "corruption" from DRILL-3867

2017-07-11 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16082118#comment-16082118 ] Vitalii Diravka edited comment on DRILL-5660 at 7/11/17 3:49 PM: -

[jira] [Commented] (DRILL-4060) CTAS to csv or json files gives incorrect time values

2017-07-10 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16080402#comment-16080402 ] Vitalii Diravka commented on DRILL-4060: It looks like when DRILL-5332 and DRILL-5334 is solved,

[jira] [Updated] (DRILL-5660) Drill 1.10 queries fail due to Parquet Metadata "corruption" from DRILL-3867

2017-07-27 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5660: --- Description: Drill recently accepted a PR for the following bug: DRILL-3867: Store relative

[jira] [Assigned] (DRILL-5377) Drill returns weird characters when parquet date auto-correction is turned off

2017-08-08 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-5377: -- Assignee: Vitalii Diravka > Drill returns weird characters when parquet date

[jira] [Assigned] (DRILL-1051) casting timestamp as date gives wrong result for dates earlier than 1797

2017-08-08 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-1051: -- Assignee: Vitalii Diravka > casting timestamp as date gives wrong result for dates

[jira] [Commented] (DRILL-1051) Casting timestamp as date gives wrong result for dates earlier than 1883

2017-08-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16133080#comment-16133080 ] Vitalii Diravka commented on DRILL-1051: The issue is connected to the JDBC and converting of Joda

[jira] [Commented] (DRILL-5377) Five-digit year dates aren't correct displayed via jdbc

2017-08-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16133082#comment-16133082 ] Vitalii Diravka commented on DRILL-5377: The root cause of the issue is that java.sql.Date cut

[jira] [Updated] (DRILL-5377) Five-digit year dates aren't correct displayed via jdbc

2017-08-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5377: --- Summary: Five-digit year dates aren't correct displayed via jdbc (was: Five-digit year dates

[jira] [Updated] (DRILL-5377) Five-digit year dates aren't correct displayed by jdbc

2017-08-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5377: --- Summary: Five-digit year dates aren't correct displayed by jdbc (was: Drill returns weird

[jira] [Comment Edited] (DRILL-5377) Five-digit year dates aren't correct displayed by jdbc

2017-08-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15945457#comment-15945457 ] Vitalii Diravka edited comment on DRILL-5377 at 8/18/17 1:49 PM: - Dates

[jira] [Updated] (DRILL-1051) casting timestamp as date gives wrong result for dates earlier than 1883

2017-08-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-1051: --- Summary: casting timestamp as date gives wrong result for dates earlier than 1883 (was:

[jira] [Updated] (DRILL-1051) Casting timestamp as date gives wrong result for dates earlier than 1883

2017-08-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-1051: --- Summary: Casting timestamp as date gives wrong result for dates earlier than 1883 (was:

[jira] [Updated] (DRILL-5377) Five-digit year dates are displayed incorrectly via jdbc

2017-08-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5377: --- Summary: Five-digit year dates are displayed incorrectly via jdbc (was: Five-digit year

[jira] [Updated] (DRILL-5377) Five-digit year dates are displayed incorrectly via jdbc

2017-08-18 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5377: --- Fix Version/s: Future > Five-digit year dates are displayed incorrectly via jdbc >

[jira] [Assigned] (DRILL-4039) Query fails when non-ascii characters are used in string literals

2017-05-03 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4039?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-4039: -- Assignee: Vitalii Diravka > Query fails when non-ascii characters are used in string

[jira] [Assigned] (DRILL-3867) Store relative paths in metadata file

2017-05-03 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-3867: -- Assignee: Vitalii Diravka (was: Mehant Baid) > Store relative paths in metadata file

[jira] [Updated] (DRILL-3867) Store relative paths in metadata file

2017-05-03 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-3867: --- Summary: Store relative paths in metadata file (was: Metadata Caching : Moving a directory

[jira] [Assigned] (DRILL-3250) Drill fails to compare multi-byte characters from hive table

2017-05-17 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-3250: -- Assignee: Vitalii Diravka > Drill fails to compare multi-byte characters from hive

[jira] [Commented] (DRILL-3250) Drill fails to compare multi-byte characters from hive table

2017-05-17 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16013945#comment-16013945 ] Vitalii Diravka commented on DRILL-3250: Fix for

[jira] [Commented] (DRILL-5002) Using hive's date functions on top of date column gives wrong results for local time-zone

2017-06-20 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16055280#comment-16055280 ] Vitalii Diravka commented on DRILL-5002: One more hive built-in function, which relies on local

[jira] [Commented] (DRILL-4721) Doc "dateDiff" in Drill

2017-06-20 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16055286#comment-16055286 ] Vitalii Diravka commented on DRILL-4721: [~bbevens] datediff() is [hive built-in

[jira] [Commented] (DRILL-4116) Inconsistent results with datetime functions on different machines

2017-06-20 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16055264#comment-16055264 ] Vitalii Diravka commented on DRILL-4116: datediff() is a [hive build-in

[jira] [Commented] (DRILL-2975) Extended Json : Time type reporting data which is dependent on the system on which it ran

2017-06-20 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16055238#comment-16055238 ] Vitalii Diravka commented on DRILL-2975: [~rkins] If these two queries are used on machines with

[jira] [Closed] (DRILL-2975) Extended Json : Time type reporting data which is dependent on the system on which it ran

2017-06-21 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka closed DRILL-2975. -- Resolution: Not A Bug Fix Version/s: (was: Future) According to the conversation in

[jira] [Assigned] (DRILL-5402) ServerMeta should be updated during the session, if the last has been changed.

2017-06-22 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-5402: -- Assignee: (was: Vitalii Diravka) > ServerMeta should be updated during the

[jira] [Updated] (DRILL-5402) ServerMeta should be updated during the session, if the last has been changed.

2017-06-22 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5402: --- Fix Version/s: (was: 1.11.0) Future > ServerMeta should be updated

[jira] [Assigned] (DRILL-5332) DateVector support uses questionable conversions to a time

2017-06-22 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka reassigned DRILL-5332: -- Assignee: (was: Vitalii Diravka) > DateVector support uses questionable

[jira] [Created] (DRILL-5603) Replacing the type of paths from String to Hadoop Path

2017-06-22 Thread Vitalii Diravka (JIRA)
Vitalii Diravka created DRILL-5603: -- Summary: Replacing the type of paths from String to Hadoop Path Key: DRILL-5603 URL: https://issues.apache.org/jira/browse/DRILL-5603 Project: Apache Drill

[jira] [Resolved] (DRILL-4116) Inconsistent results with datetime functions on different machines

2017-06-27 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka resolved DRILL-4116. Resolution: Duplicate [DRILL-5002|https://issues.apache.org/jira/browse/DRILL-5002] jira

[jira] [Updated] (DRILL-5544) Out of heap running CTAS against text delimited

2017-05-26 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5544: --- Environment: - 2 or 4 nodes cluster - 4G or 8G of Java heap and more than 8G of direct memory

[jira] [Created] (DRILL-5544) Out of heap running CTAS against text delimited

2017-05-26 Thread Vitalii Diravka (JIRA)
Vitalii Diravka created DRILL-5544: -- Summary: Out of heap running CTAS against text delimited Key: DRILL-5544 URL: https://issues.apache.org/jira/browse/DRILL-5544 Project: Apache Drill

[jira] [Updated] (DRILL-5544) Out of heap running CTAS against text delimited

2017-05-26 Thread Vitalii Diravka (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vitalii Diravka updated DRILL-5544: --- Description: This query causes the drillbit to hang: {code} create table xyz as select

<    1   2   3   4   5   6   7   8   9   10   >