[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:

[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

[jira] [Created] (DRILL-6981) command line option to choose/force drill-override.conf

2019-01-16 Thread benj (JIRA)
benj created DRILL-6981: --- Summary: command line option to choose/force drill-override.conf Key: DRILL-6981 URL: https://issues.apache.org/jira/browse/DRILL-6981 Project: Apache Drill Issue Type: Wish

[jira] [Created] (DRILL-6984) from table escape parameter not deleted when defined with value other than '"'

2019-01-17 Thread benj (JIRA)
benj created DRILL-6984: --- Summary: from table escape parameter not deleted when defined with value other than '"' Key: DRILL-6984 URL: https://issues.apache.org/jira/browse/DRILL-6984 Project: Apache Drill

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

2019-01-18 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16746340#comment-16746340 ] benj commented on DRILL-6962: - Exact, the correct syntax (that works) is :   {code:java} SELECT

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

2019-01-15 Thread benj (JIRA)
benj created DRILL-6978: --- Summary: typeOf drillTypeOf sqlTypeOf not work with generated tables Key: DRILL-6978 URL: https://issues.apache.org/jira/browse/DRILL-6978 Project: Apache Drill Issue Type:

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

2019-01-14 Thread benj (JIRA)
benj created DRILL-6975: --- Summary: TO_CHAR does not seems work well depends on LOCALE Key: DRILL-6975 URL: https://issues.apache.org/jira/browse/DRILL-6975 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-6973) Improve --run (ability to run query and get result in a good format from command line)

2019-01-21 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16747988#comment-16747988 ] benj commented on DRILL-6973: - Yes, I have missed this new option of 1.15.0

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

2019-01-21 Thread benj (JIRA)
benj created DRILL-6988: --- Summary: Utility of the too long error message when syntax error Key: DRILL-6988 URL: https://issues.apache.org/jira/browse/DRILL-6988 Project: Apache Drill Issue Type:

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

2019-01-21 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16747905#comment-16747905 ] benj commented on DRILL-6963: - Sure, for example, PostgreSQL has these kind of functionality * Work with

[jira] [Created] (DRILL-6987) sqlline - simple semicolon ";" with no command produce error

2019-01-21 Thread benj (JIRA)
benj created DRILL-6987: --- Summary: sqlline - simple semicolon ";" with no command produce error Key: DRILL-6987 URL: https://issues.apache.org/jira/browse/DRILL-6987 Project: Apache Drill Issue Type:

[jira] [Commented] (DRILL-6987) sqlline - simple semicolon ";" with no command produce error

2019-01-22 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16748571#comment-16748571 ] benj commented on DRILL-6987: - OK. So, for monitoring, I created a related issue on

[jira] [Created] (DRILL-6980) --run regression - error when empty line or command at end of the file

2019-01-16 Thread benj (JIRA)
benj created DRILL-6980: --- Summary: --run regression - error when empty line or command at end of the file Key: DRILL-6980 URL: https://issues.apache.org/jira/browse/DRILL-6980 Project: Apache Drill

[jira] [Commented] (DRILL-6981) command line option to choose/force drill-override.conf

2019-01-18 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16745906#comment-16745906 ] benj commented on DRILL-6981: - I agree with that. But with several instance with common/identical files on

[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:

[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:

[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

[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:

[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

[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=16740175#comment-16740175 ] benj edited comment on DRILL-6962 at 1/11/19 8:54 AM: -- In 1.15.0 it's not exactly

[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=16740175#comment-16740175 ] benj commented on DRILL-6962: - In 1.15.0 it's not exactly the same error message but the same idea :

[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

[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:

[jira] [Created] (DRILL-6973) Improve --run (ability to run query and get result in a good format from command line)

2019-01-14 Thread benj (JIRA)
benj created DRILL-6973: --- Summary: Improve --run (ability to run query and get result in a good format from command line) Key: DRILL-6973 URL: https://issues.apache.org/jira/browse/DRILL-6973 Project: Apache

[jira] [Created] (DRILL-6974) SET/SHOW

2019-01-14 Thread benj (JIRA)
benj created DRILL-6974: --- Summary: SET/SHOW Key: DRILL-6974 URL: https://issues.apache.org/jira/browse/DRILL-6974 Project: Apache Drill Issue Type: Improvement Components: SQL Parser

[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=16801567#comment-16801567 ] benj commented on DRILL-7104: - A little trick to get around this problem until someone can fix it. Use a

[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=16809611#comment-16809611 ] benj edited comment on DRILL-7067 at 4/4/19 8:32 AM: - Could you check the mode and

[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=16809611#comment-16809611 ] benj commented on DRILL-7067: - Could you check the mode (modeof(`field`)) of the fields of your differents

[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=16809611#comment-16809611 ] benj edited comment on DRILL-7067 at 4/4/19 8:33 AM: - Could you check the mode and

[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=16784465#comment-16784465 ] benj commented on DRILL-6988: - in org/apache/drill/exec/planner/sql/parser/impl/ParseException.java Why not

[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] [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=16792820#comment-16792820 ] benj commented on DRILL-7104: - For more precision : With the correct file "nobug" {code:java} hadoop jar

[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

[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

[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=16765927#comment-16765927 ] benj edited comment on DRILL-1330 at 3/11/19 2:02 PM: -- Any news/advance/projection

[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=16789628#comment-16789628 ] benj commented on DRILL-7090: - In the same way but without any Parquet {code:java} SELECT t1, count(*) FROM

[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=16797211#comment-16797211 ] benj commented on DRILL-4092: - Until the feature is implemented, there are queries to achieve the same

[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=16797093#comment-16797093 ] benj commented on DRILL-4232: - Until the feature is implemented, there are queries to achieve the same

[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=16797093#comment-16797093 ] benj edited comment on DRILL-4232 at 3/20/19 1:59 PM: -- Until the feature is

[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=16798891#comment-16798891 ] benj commented on DRILL-7104: - With the request that build Parquet with more than 1 Fragment, if you add an

[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

[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:

[jira] [Comment Edited] (DRILL-7034) Window function over a malformed CSV file crashes the JVM

2019-02-12 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16765973#comment-16765973 ] benj edited comment on DRILL-7034 at 2/12/19 12:32 PM: --- Maybe it's not only a

[jira] [Commented] (DRILL-7034) Window function over a malformed CSV file crashes the JVM

2019-02-12 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16765973#comment-16765973 ] benj commented on DRILL-7034: - Maybe it's not a problem of windows function. A

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

2019-02-12 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16765927#comment-16765927 ] benj commented on DRILL-1330: - Any news/advance/projection on this very old topic but in fact one of the

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

2019-02-12 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16765927#comment-16765927 ] benj edited comment on DRILL-1330 at 2/12/19 11:14 AM: --- Any news/advance/projection

[jira] [Created] (DRILL-7003) aggregate all columns

2019-01-25 Thread benj (JIRA)
benj created DRILL-7003: --- Summary: aggregate all columns Key: DRILL-7003 URL: https://issues.apache.org/jira/browse/DRILL-7003 Project: Apache Drill Issue Type: Wish Components: Functions -

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

2019-01-25 Thread benj (JIRA)
benj created DRILL-7004: --- Summary: improve show files functionnality Key: DRILL-7004 URL: https://issues.apache.org/jira/browse/DRILL-7004 Project: Apache Drill Issue Type: Wish Components:

[jira] [Created] (DRILL-7001) Documentation - renaming columns name in csv header

2019-01-24 Thread benj (JIRA)
benj created DRILL-7001: --- Summary: Documentation - renaming columns name in csv header Key: DRILL-7001 URL: https://issues.apache.org/jira/browse/DRILL-7001 Project: Apache Drill Issue Type: Wish

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

2019-01-25 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16752402#comment-16752402 ] benj commented on DRILL-7004: - Nice, it had escaped me (maybe I need to buy new eyes). Thanks. I find that

[jira] [Commented] (DRILL-5762) CSV having header column by name "suffix" fails to load

2019-01-24 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16751221#comment-16751221 ] benj commented on DRILL-5762: - In continuation of this subject-- Some words are reserved keyword for drill.

[jira] [Created] (DRILL-7017) lz4 codec for (un)compression

2019-01-30 Thread benj (JIRA)
benj created DRILL-7017: --- Summary: lz4 codec for (un)compression Key: DRILL-7017 URL: https://issues.apache.org/jira/browse/DRILL-7017 Project: Apache Drill Issue Type: Wish Components:

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

2019-01-30 Thread benj (JIRA)
benj created DRILL-7020: --- Summary: big varchar doesn't work with extractHeader=true Key: DRILL-7020 URL: https://issues.apache.org/jira/browse/DRILL-7020 Project: Apache Drill Issue Type: Bug

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

2019-01-31 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16757288#comment-16757288 ] benj commented on DRILL-4232: - Duplicate ticket as DRILL-4224 (MINUS and EXCEPT are alias) But very expected

[jira] [Commented] (DRILL-923) Bit wise and logical Aggregate functions

2019-01-31 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16757269#comment-16757269 ] benj commented on DRILL-923: Please updating documentation in which these functions do not appear :

[jira] [Commented] (DRILL-7017) lz4 codec for (un)compression

2019-01-31 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16757258#comment-16757258 ] benj commented on DRILL-7017: - lz4 is well in the list of supported compression. Searched a lot to try to

[jira] [Commented] (DRILL-7001) Documentation - renaming columns name in csv header

2019-01-28 Thread benj (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753836#comment-16753836 ] benj commented on DRILL-7001: - I think the most problematic was the silent drop of columns (not evocated

[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=16818954#comment-16818954 ] benj commented on DRILL-7020: - Note that this problem of course exists +for every csvh+ file that contains at

[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=16797211#comment-16797211 ] benj edited comment on DRILL-4092 at 4/18/19 11:08 AM: --- Until the feature is

[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=16820990#comment-16820990 ] benj commented on DRILL-4232: - Of course, It's also possible to simulate *EXCEPT ALL* {code:java} SELECT a

[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] [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

[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

[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=16842169#comment-16842169 ] benj commented on DRILL-3727: - Spark SQL convert to NULL failed cast {code:java} spark.sql("""SELECT CAST(f

[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

[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=16858714#comment-16858714 ] benj commented on DRILL-7288: - Please note that when using a column instead constant there is no problem:

[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] [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=16869614#comment-16869614 ] benj commented on DRILL-6958: - Currently when you CTAS on csv format, if you have some text columns that

[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, *

[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:

[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] [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-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:

[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:

[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:

[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

[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] [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=16844937#comment-16844937 ] benj commented on DRILL-4224: - See Drill-4232 > Support MINUS set operator > -- > >

[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-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] [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=16882034#comment-16882034 ] benj commented on DRILL-6968: - The _split_to_array_ is currently well defined as *split()* function (from

[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

[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] [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=16905219#comment-16905219 ] benj commented on DRILL-7050: - Just to illustrate in a real case (simplified here) the problem pointed by

[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=16905017#comment-16905017 ] benj commented on DRILL-7342: - To avoid other surprise of this type, please look list of different rules

[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=16905904#comment-16905904 ] benj commented on DRILL-7050: - Hi [~vvysotskyi], please note that "surprisingly" from Calcite, [~julianhyde]

[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=16895317#comment-16895317 ] benj edited comment on DRILL-6968 at 9/2/19 12:48 PM: -- OK, I found that unnest is

[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=16882034#comment-16882034 ] benj edited comment on DRILL-6968 at 9/2/19 12:44 PM: -- The _split_to_array_ is

[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-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] [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] [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=16927527#comment-16927527 ] benj commented on DRILL-7371: - [~vvysotskyi], the problem occurs on all Daylight Saving Time of Europe

[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-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

[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) >

[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

[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

  1   2   >