[jira] [Commented] (DRILL-6988) Utility of the too long error message when syntax error

2019-03-05 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16784465#comment-16784465 ] benj commented on DRILL-6988: - in org/apache/drill/exec/planner/sql/parser/impl/ParseExceptio

[jira] [Created] (DRILL-7090) Improve management of Optional(Nullable) / Required(Not nullable) type at least for parquet storage

2019-03-11 Thread benj (JIRA)
benj created DRILL-7090: --- Summary: Improve management of Optional(Nullable) / Required(Not nullable) type at least for parquet storage Key: DRILL-7090 URL: https://issues.apache.org/jira/browse/DRILL-7090 Proje

[jira] [Comment Edited] (DRILL-1330) String aggregate function - string_agg(expression, delimiter)

2019-03-11 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16765927#comment-16765927 ] benj edited comment on DRILL-1330 at 3/11/19 2:02 PM: -- Any news/adva

[jira] [Commented] (DRILL-7090) Improve management of Optional(Nullable) / Required(Not nullable) type at least for parquet storage

2019-03-11 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16789628#comment-16789628 ] benj commented on DRILL-7090: - In the same way but without any Parquet {code:java} SELECT t1,

[jira] [Created] (DRILL-7104) Change of data type when parquet with multiple fragment

2019-03-14 Thread benj (JIRA)
benj created DRILL-7104: --- Summary: Change of data type when parquet with multiple fragment Key: DRILL-7104 URL: https://issues.apache.org/jira/browse/DRILL-7104 Project: Apache Drill Issue Type: Bug

[jira] [Updated] (DRILL-7104) Change of data type when parquet with multiple fragment

2019-03-14 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7104?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7104: Description: When creating a Parquet with a column filled only with "CAST(NULL AS VARCHAR)", if the parquet has se

[jira] [Commented] (DRILL-7104) Change of data type when parquet with multiple fragment

2019-03-14 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16792820#comment-16792820 ] benj commented on DRILL-7104: - For more precision : With the correct file "nobug" {code:java

[jira] [Commented] (DRILL-4232) Support for EXCEPT set operator

2019-03-20 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16797093#comment-16797093 ] benj commented on DRILL-4232: - Until the feature is implemented, there are queries to achieve

[jira] [Comment Edited] (DRILL-4232) Support for EXCEPT set operator

2019-03-20 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16797093#comment-16797093 ] benj edited comment on DRILL-4232 at 3/20/19 1:59 PM: -- Until the fea

[jira] [Commented] (DRILL-4092) Support for INTERSECT

2019-03-20 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16797211#comment-16797211 ] benj commented on DRILL-4092: - Until the feature is implemented, there are queries to achieve

[jira] [Updated] (DRILL-7104) Change of data type when parquet with multiple fragment

2019-03-22 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7104?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7104: Attachment: DRILL-7104_ErrorNumberFormatException_20190322.log > Change of data type when parquet with multiple fra

[jira] [Commented] (DRILL-7104) Change of data type when parquet with multiple fragment

2019-03-22 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16798891#comment-16798891 ] benj commented on DRILL-7104: - With the request that build Parquet with more than 1 Fragment,

[jira] [Created] (DRILL-7131) generate_series / generator

2019-03-22 Thread benj (JIRA)
benj created DRILL-7131: --- Summary: generate_series / generator Key: DRILL-7131 URL: https://issues.apache.org/jira/browse/DRILL-7131 Project: Apache Drill Issue Type: Wish Components: Functio

[jira] [Commented] (DRILL-7104) Change of data type when parquet with multiple fragment

2019-03-26 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16801567#comment-16801567 ] benj commented on DRILL-7104: - A little trick to get around this problem until someone can fi

[jira] [Commented] (DRILL-7067) Querying parquet file with null value field error

2019-04-04 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16809611#comment-16809611 ] benj commented on DRILL-7067: - Could you check the mode (modeof(`field`)) of the fields of yo

[jira] [Comment Edited] (DRILL-7067) Querying parquet file with null value field error

2019-04-04 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16809611#comment-16809611 ] benj edited comment on DRILL-7067 at 4/4/19 8:32 AM: - Could you check

[jira] [Comment Edited] (DRILL-7067) Querying parquet file with null value field error

2019-04-04 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16809611#comment-16809611 ] benj edited comment on DRILL-7067 at 4/4/19 8:33 AM: - Could you check

[jira] [Created] (DRILL-7175) Configuration of store.parquet.use_new_reader in drill-override.conf has no effect

2019-04-13 Thread benj (JIRA)
benj created DRILL-7175: --- Summary: Configuration of store.parquet.use_new_reader in drill-override.conf has no effect Key: DRILL-7175 URL: https://issues.apache.org/jira/browse/DRILL-7175 Project: Apache Drill

[jira] [Commented] (DRILL-7020) big varchar doesn't work with extractHeader=true

2019-04-16 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818954#comment-16818954 ] benj commented on DRILL-7020: - Note that this problem of course exists +for every csvh+ file

[jira] [Comment Edited] (DRILL-4092) Support for INTERSECT

2019-04-18 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16797211#comment-16797211 ] benj edited comment on DRILL-4092 at 4/18/19 11:08 AM: --- Until the f

[jira] [Commented] (DRILL-4232) Support for EXCEPT set operator

2019-04-18 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16820990#comment-16820990 ] benj commented on DRILL-4232: - Of course, It's also possible to simulate *EXCEPT ALL* {code:j

[jira] [Created] (DRILL-7219) Ignore hidden file problems

2019-04-26 Thread benj (JIRA)
benj created DRILL-7219: --- Summary: Ignore hidden file problems Key: DRILL-7219 URL: https://issues.apache.org/jira/browse/DRILL-7219 Project: Apache Drill Issue Type: Bug Components: Storage

[jira] [Created] (DRILL-7243) Storage Plugins Management

2019-05-07 Thread benj (JIRA)
benj created DRILL-7243: --- Summary: Storage Plugins Management Key: DRILL-7243 URL: https://issues.apache.org/jira/browse/DRILL-7243 Project: Apache Drill Issue Type: Bug Components: Storage -

[jira] [Created] (DRILL-7246) DESCRIBE on Parquet File

2019-05-09 Thread benj (JIRA)
benj created DRILL-7246: --- Summary: DESCRIBE on Parquet File Key: DRILL-7246 URL: https://issues.apache.org/jira/browse/DRILL-7246 Project: Apache Drill Issue Type: Improvement Components: Sto

[jira] [Created] (DRILL-7247) Use result of DESCRIBE as a SELECT

2019-05-09 Thread benj (JIRA)
benj created DRILL-7247: --- Summary: Use result of DESCRIBE as a SELECT Key: DRILL-7247 URL: https://issues.apache.org/jira/browse/DRILL-7247 Project: Apache Drill Issue Type: Improvement Compo

[jira] [Updated] (DRILL-7247) Use result of DESCRIBE as a SELECT

2019-05-09 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7247: Description: It would be usefull to be able to use the result of a DESCRIBE command like a SELECT. Examples: {cod

[jira] [Updated] (DRILL-7247) Use result of DESCRIBE as a SELECT

2019-05-09 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7247: Description: It would be usefull to be able to use the result of a DESCRIBE command like a SELECT. Examples: {cod

[jira] [Created] (DRILL-7260) Error on clause that should not be evaluated

2019-05-15 Thread benj (JIRA)
benj created DRILL-7260: --- Summary: Error on clause that should not be evaluated Key: DRILL-7260 URL: https://issues.apache.org/jira/browse/DRILL-7260 Project: Apache Drill Issue Type: Bug Com

[jira] [Commented] (DRILL-3727) Drill should return NULL instead of failure if cast column is empty

2019-05-17 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16842169#comment-16842169 ] benj commented on DRILL-3727: - Spark SQL convert to NULL failed cast {code:java} spark.sql(""

[jira] [Created] (DRILL-7265) Cast/To_type with on error handling

2019-05-17 Thread benj (JIRA)
benj created DRILL-7265: --- Summary: Cast/To_type with on error handling Key: DRILL-7265 URL: https://issues.apache.org/jira/browse/DRILL-7265 Project: Apache Drill Issue Type: Improvement Comp

[jira] [Commented] (DRILL-4224) Support MINUS set operator

2019-05-21 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16844937#comment-16844937 ] benj commented on DRILL-4224: - See Drill-4232 > Support MINUS set operator > ---

[jira] [Closed] (DRILL-6954) Move commons libs used in UDFs module to the dependency management

2019-05-21 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj closed DRILL-6954. --- OK In 1.16 > Move commons libs used in UDFs module to the dependency management > --

[jira] [Closed] (DRILL-6978) typeOf drillTypeOf sqlTypeOf not work with generated tables

2019-05-21 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj closed DRILL-6978. --- Fixed in 1.16 > typeOf drillTypeOf sqlTypeOf not work with generated tables > --

[jira] [Created] (DRILL-7288) IndexOutOfBoundsException when coalesce(dir0,'')

2019-06-07 Thread benj (JIRA)
benj created DRILL-7288: --- Summary: IndexOutOfBoundsException when coalesce(dir0,'') Key: DRILL-7288 URL: https://issues.apache.org/jira/browse/DRILL-7288 Project: Apache Drill Issue Type: Bug Affec

[jira] [Commented] (DRILL-7288) IndexOutOfBoundsException when coalesce(dir0,'')

2019-06-07 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16858714#comment-16858714 ] benj commented on DRILL-7288: - Please note that when using a column instead constant there is

[jira] [Created] (DRILL-7291) parquet with compression gzip doesn't work well

2019-06-12 Thread benj (JIRA)
benj created DRILL-7291: --- Summary: parquet with compression gzip doesn't work well Key: DRILL-7291 URL: https://issues.apache.org/jira/browse/DRILL-7291 Project: Apache Drill Issue Type: Bug

[jira] [Updated] (DRILL-6958) CTAS csv with option

2019-06-21 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-6958: Description: Add some options to write CSV file with CTAS : * possibility to change/define the separator, * possi

[jira] [Commented] (DRILL-6958) CTAS csv with option

2019-06-21 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16869614#comment-16869614 ] benj commented on DRILL-6958: - Currently when you CTAS on csv format, if you have some text c

[jira] [Updated] (DRILL-6958) CTAS csv with option

2019-06-24 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-6958: Affects Version/s: 1.16.0 > CTAS csv with option > > > Key: DRILL-6958 >

[jira] [Updated] (DRILL-6958) CTAS csv with option

2019-06-24 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-6958: Issue Type: Bug (was: Improvement) > CTAS csv with option > > > Key: DRILL-69

[jira] [Updated] (DRILL-6958) CTAS csv with option

2019-06-24 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-6958: Description: Currently, it may be difficult to produce well-formed CSV with CTAS (see comment below). It appears

[jira] [Created] (DRILL-7319) Option to request NOT NULL column as NULLABLE column

2019-07-08 Thread benj (JIRA)
benj created DRILL-7319: --- Summary: Option to request NOT NULL column as NULLABLE column Key: DRILL-7319 URL: https://issues.apache.org/jira/browse/DRILL-7319 Project: Apache Drill Issue Type: Improveme

[jira] [Created] (DRILL-7321) split function doesn't work without from

2019-07-10 Thread benj (JIRA)
benj created DRILL-7321: --- Summary: split function doesn't work without from Key: DRILL-7321 URL: https://issues.apache.org/jira/browse/DRILL-7321 Project: Apache Drill Issue Type: Bug Compone

[jira] [Commented] (DRILL-6968) pattern matching and regexp facilities

2019-07-10 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16882034#comment-16882034 ] benj commented on DRILL-6968: - The _split_to_array_ is currently well defined as *split()* fu

[jira] [Commented] (DRILL-6968) pattern matching and regexp facilities

2019-07-29 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16895317#comment-16895317 ] benj commented on DRILL-6968: - OK, I found that unnest is implemented even it's not really we

[jira] [Updated] (DRILL-6968) pattern matching and regexp facilities and unnest

2019-07-29 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-6968: Summary: pattern matching and regexp facilities and unnest (was: pattern matching and regexp facilities) > patter

[jira] [Commented] (DRILL-7342) Drill replacing spaces with underlines in the column names of text files with headers

2019-08-12 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905017#comment-16905017 ] benj commented on DRILL-7342: - To avoid other surprise of this type, please look list of diff

[jira] [Commented] (DRILL-7050) RexNode convert exception in subquery

2019-08-12 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905219#comment-16905219 ] benj commented on DRILL-7050: - Just to illustrate in a real case (simplified here) the proble

[jira] [Commented] (DRILL-7050) RexNode convert exception in subquery

2019-08-13 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905904#comment-16905904 ] benj commented on DRILL-7050: - Hi [~vvysotskyi], please note that "surprisingly" from Calcite

[jira] [Comment Edited] (DRILL-6968) pattern matching and regexp facilities and unnest

2019-09-02 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-6968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16882034#comment-16882034 ] benj edited comment on DRILL-6968 at 9/2/19 12:44 PM: -- The _split_to

[jira] [Comment Edited] (DRILL-6968) pattern matching and regexp facilities and unnest

2019-09-02 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-6968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16895317#comment-16895317 ] benj edited comment on DRILL-6968 at 9/2/19 12:48 PM: -- OK, I found t

[jira] [Created] (DRILL-7371) DST/UTC problem

2019-09-11 Thread benj (Jira)
benj created DRILL-7371: --- Summary: DST/UTC problem Key: DRILL-7371 URL: https://issues.apache.org/jira/browse/DRILL-7371 Project: Apache Drill Issue Type: Bug Components: Functions - Drill

[jira] [Updated] (DRILL-7371) DST/UTC cast/to_timestamp problem

2019-09-11 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7371: Summary: DST/UTC cast/to_timestamp problem (was: DST/UTC problem) > DST/UTC cast/to_timestamp problem > --

[jira] [Commented] (DRILL-7371) DST/UTC cast/to_timestamp problem

2019-09-11 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16927527#comment-16927527 ] benj commented on DRILL-7371: - [~vvysotskyi], the problem occurs on all Daylight Saving Time

[jira] [Updated] (DRILL-7371) DST/UTC cast/to_timestamp problem

2019-09-11 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7371: Component/s: Client - JDBC > DST/UTC cast/to_timestamp problem > - > >

[jira] [Updated] (DRILL-6975) TO_CHAR does not seems work well depends on LOCALE

2019-09-11 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-6975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-6975: Affects Version/s: 1.14.0 1.16.0 > TO_CHAR does not seems work well depends on LOCALE >

[jira] [Created] (DRILL-7375) composite type map cast/convert_to

2019-09-13 Thread benj (Jira)
benj created DRILL-7375: --- Summary: composite type map cast/convert_to Key: DRILL-7375 URL: https://issues.apache.org/jira/browse/DRILL-7375 Project: Apache Drill Issue Type: Wish Components:

[jira] [Updated] (DRILL-7375) composite type map cast/convert_to

2019-09-16 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7375: Description: As it possible to cast varchar to map (JSON) with convert_from {code:sql} SELECT a, typeof(a) from (SE

[jira] [Updated] (DRILL-7375) composite type map cast/convert_to

2019-09-16 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7375: Description: As it possible to cast varchar to map (JSON) with convert_from {code:sql} SELECT a, typeof(a) from (SE

[jira] [Updated] (DRILL-7375) composite type map cast/convert_to

2019-09-16 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7375: Description: As it possible to cast varchar to map (JSON) with convert_from {code:sql} SELECT a, typeof(a) from (SE

[jira] [Updated] (DRILL-7375) composite type map cast/convert_to

2019-09-16 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7375: Description: As it possible to cast varchar to map (convert_from + JSON) with convert_from or transform a varchar

[jira] [Updated] (DRILL-7375) composite type map cast/convert_to

2019-09-16 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7375: Description: As it possible to cast varchar to map (convert_from + JSON) with convert_from or transform a varchar

[jira] [Updated] (DRILL-7375) composite/nested type map/array convert_to/cast to varchar

2019-09-16 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7375: Summary: composite/nested type map/array convert_to/cast to varchar (was: composite type map cast/convert_to) > c

[jira] [Created] (DRILL-7378) Allowing less outer/inner select

2019-09-19 Thread benj (Jira)
benj created DRILL-7378: --- Summary: Allowing less outer/inner select Key: DRILL-7378 URL: https://issues.apache.org/jira/browse/DRILL-7378 Project: Apache Drill Issue Type: Improvement Compone

[jira] [Created] (DRILL-7379) Planning error

2019-09-19 Thread benj (Jira)
benj created DRILL-7379: --- Summary: Planning error Key: DRILL-7379 URL: https://issues.apache.org/jira/browse/DRILL-7379 Project: Apache Drill Issue Type: Bug Components: Functions - Drill

[jira] [Commented] (DRILL-6958) CTAS csv with option

2019-09-23 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-6958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16935943#comment-16935943 ] benj commented on DRILL-6958: - In the next example, with a table with a column that contain a

[jira] [Created] (DRILL-7389) JSON empty list avoid Parquet creation

2019-09-27 Thread benj (Jira)
benj created DRILL-7389: --- Summary: JSON empty list avoid Parquet creation Key: DRILL-7389 URL: https://issues.apache.org/jira/browse/DRILL-7389 Project: Apache Drill Issue Type: Improvement C

[jira] [Created] (DRILL-7390) kvgen/flatten doesn't produce same result from .json or .parquet

2019-09-27 Thread benj (Jira)
benj created DRILL-7390: --- Summary: kvgen/flatten doesn't produce same result from .json or .parquet Key: DRILL-7390 URL: https://issues.apache.org/jira/browse/DRILL-7390 Project: Apache Drill Issue Ty

[jira] [Created] (DRILL-7392) Exclude some files when requesting directory

2019-10-01 Thread benj (Jira)
benj created DRILL-7392: --- Summary: Exclude some files when requesting directory Key: DRILL-7392 URL: https://issues.apache.org/jira/browse/DRILL-7392 Project: Apache Drill Issue Type: Wish

[jira] [Commented] (DRILL-7004) improve show files functionnality

2019-10-02 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16942863#comment-16942863 ] benj commented on DRILL-7004: - Despite the parallelization, for a system containing several h

[jira] [Commented] (DRILL-7004) improve show files functionnality

2019-10-02 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16943152#comment-16943152 ] benj commented on DRILL-7004: - Ok, thanks for the precision. Note that in a suprising way, i

[jira] [Created] (DRILL-7395) Partial Partition By to CTAS Parquet files

2019-10-03 Thread benj (Jira)
benj created DRILL-7395: --- Summary: Partial Partition By to CTAS Parquet files Key: DRILL-7395 URL: https://issues.apache.org/jira/browse/DRILL-7395 Project: Apache Drill Issue Type: Improvement

[jira] [Created] (DRILL-7396) Exception when trying to access last element of an array with repeated_count

2019-10-04 Thread benj (Jira)
benj created DRILL-7396: --- Summary: Exception when trying to access last element of an array with repeated_count Key: DRILL-7396 URL: https://issues.apache.org/jira/browse/DRILL-7396 Project: Apache Drill

[jira] [Commented] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-04 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16944585#comment-16944585 ] benj commented on DRILL-7291: - Indeed, surprisingly, I can't reproduce the problem with the f

[jira] [Comment Edited] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-07 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16944585#comment-16944585 ] benj edited comment on DRILL-7291 at 10/7/19 9:44 AM: -- Indeed, surpr

[jira] [Comment Edited] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-07 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16944585#comment-16944585 ] benj edited comment on DRILL-7291 at 10/7/19 9:55 AM: -- Indeed, surpr

[jira] [Updated] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-07 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7291: Attachment: short_no_binary_quote.csvh > parquet with compression gzip doesn't work well >

[jira] [Commented] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-07 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16945825#comment-16945825 ] benj commented on DRILL-7291: - Sure, sorry for the delay but I preferred to double check some

[jira] [Commented] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-07 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16945871#comment-16945871 ] benj commented on DRILL-7291: - In fact, the problem appear in +embeded mode+ (bin/drill-embed

[jira] [Commented] (DRILL-7348) Aggregate on Subquery with Select Distinct or UNION fails to Group By

2019-10-09 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16947512#comment-16947512 ] benj commented on DRILL-7348: - I have tested in 1.15 and 1.16. I think thata the problem of [

[jira] [Comment Edited] (DRILL-7348) Aggregate on Subquery with Select Distinct or UNION fails to Group By

2019-10-09 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16947512#comment-16947512 ] benj edited comment on DRILL-7348 at 10/9/19 10:01 AM: --- I have test

[jira] [Commented] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-11 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16949501#comment-16949501 ] benj commented on DRILL-7291: - Exactly done the same as you (see below), but obtain an "+Erro

[jira] [Updated] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-11 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7291: Attachment: sqlline_error.log > parquet with compression gzip doesn't work well > -

[jira] [Commented] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-11 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16949569#comment-16949569 ] benj commented on DRILL-7291: - Please find in attchment the error log [^sqlline_error.log] I

[jira] [Commented] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-14 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16950784#comment-16950784 ] benj commented on DRILL-7291: - [~arina] you are right, with the option +store.parquet.use_new

[jira] [Updated] (DRILL-7246) DESCRIBE on Parquet File

2019-10-14 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7246: Description: It will be nice if it's possible to use DESCRIBE on Parquet File. Example : {code:sql} DESCRIBE dfs.t

[jira] [Updated] (DRILL-7291) parquet with compression gzip doesn't work well

2019-10-14 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7291: Component/s: Documentation > parquet with compression gzip doesn't work well >

[jira] [Created] (DRILL-7404) window function RANGE with compound ORDER BY

2019-10-14 Thread benj (Jira)
benj created DRILL-7404: --- Summary: window function RANGE with compound ORDER BY Key: DRILL-7404 URL: https://issues.apache.org/jira/browse/DRILL-7404 Project: Apache Drill Issue Type: Improvement

[jira] [Created] (DRILL-6940) CTAS partition parquet file with non existant columns

2018-12-31 Thread benj (JIRA)
benj created DRILL-6940: --- Summary: CTAS partition parquet file with non existant columns Key: DRILL-6940 URL: https://issues.apache.org/jira/browse/DRILL-6940 Project: Apache Drill Issue Type: Improvem

[jira] [Created] (DRILL-6943) SELECT n time the same field in json

2019-01-03 Thread benj (JIRA)
benj created DRILL-6943: --- Summary: SELECT n time the same field in json Key: DRILL-6943 URL: https://issues.apache.org/jira/browse/DRILL-6943 Project: Apache Drill Issue Type: Bug Components:

[jira] [Updated] (DRILL-6943) SELECT n time the same field in json

2019-01-07 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-6943: Fix Version/s: 1.15.0 > SELECT n time the same field in json > > >

[jira] [Closed] (DRILL-6943) SELECT n time the same field in json

2019-01-07 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj closed DRILL-6943. --- Resolution: Fixed The problem is not reproducible in 1.15.0 Probably corrected. > SELECT n time the same field in j

[jira] [Created] (DRILL-6948) Defaults values not homogeneous

2019-01-07 Thread benj (JIRA)
benj created DRILL-6948: --- Summary: Defaults values not homogeneous Key: DRILL-6948 URL: https://issues.apache.org/jira/browse/DRILL-6948 Project: Apache Drill Issue Type: Bug Components: Stor

[jira] [Created] (DRILL-6954) ADDRESS_COUNT doesn't work anymore

2019-01-08 Thread benj (JIRA)
benj created DRILL-6954: --- Summary: ADDRESS_COUNT doesn't work anymore Key: DRILL-6954 URL: https://issues.apache.org/jira/browse/DRILL-6954 Project: Apache Drill Issue Type: Bug Components: F

[jira] [Created] (DRILL-6958) CTAS csv with option

2019-01-09 Thread benj (JIRA)
benj created DRILL-6958: --- Summary: CTAS csv with option Key: DRILL-6958 URL: https://issues.apache.org/jira/browse/DRILL-6958 Project: Apache Drill Issue Type: Improvement Components: Storage

[jira] [Created] (DRILL-6963) create/aggregate/work with array

2019-01-10 Thread benj (JIRA)
benj created DRILL-6963: --- Summary: create/aggregate/work with array Key: DRILL-6963 URL: https://issues.apache.org/jira/browse/DRILL-6963 Project: Apache Drill Issue Type: Wish Components: Fu

[jira] [Comment Edited] (DRILL-6962) Function coalesce returns an Error when none of the columns in coalesce exist in a parquet file

2019-01-11 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16740175#comment-16740175 ] benj edited comment on DRILL-6962 at 1/11/19 8:54 AM: -- In 1.15.0 it'

[jira] [Commented] (DRILL-6962) Function coalesce returns an Error when none of the columns in coalesce exist in a parquet file

2019-01-11 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16740175#comment-16740175 ] benj commented on DRILL-6962: - In 1.15.0 it's not exactly the same error message but the same

[jira] [Updated] (DRILL-6963) create/aggregate/work with array

2019-01-11 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-6963: Description: * Add the possibility to build array (like : SELECT array[a1,a2,a3...]) - ideally work with all types

[jira] [Created] (DRILL-6968) pattern matching and regexp facilities

2019-01-11 Thread benj (JIRA)
benj created DRILL-6968: --- Summary: pattern matching and regexp facilities Key: DRILL-6968 URL: https://issues.apache.org/jira/browse/DRILL-6968 Project: Apache Drill Issue Type: Wish Componen

  1   2   >