[jira] [Commented] (DRILL-8481) Ability to query XML root attributes

2024-02-27 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-8481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17821298#comment-17821298 ] benj commented on DRILL-8481: - Hi [~cgivre], It's just a bug report or rather a request for evolution. >

[jira] [Updated] (DRILL-8481) Ability to query XML root attributes

2024-02-27 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-8481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-8481: Summary: Ability to query XML root attributes (was: Ability to query root attributes) > Ability to query XML

[jira] [Created] (DRILL-8481) Ability to query root attributes

2024-02-27 Thread benj (Jira)
benj created DRILL-8481: --- Summary: Ability to query root attributes Key: DRILL-8481 URL: https://issues.apache.org/jira/browse/DRILL-8481 Project: Apache Drill Issue Type: Improvement

[jira] [Comment Edited] (DRILL-7740) LEAST and GREATEST does not work well with date in embedded mode

2021-07-16 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17382023#comment-17382023 ] benj edited comment on DRILL-7740 at 7/16/21, 12:13 PM: Le problème semble avoir

[jira] [Commented] (DRILL-7740) LEAST and GREATEST does not work well with date in embedded mode

2021-07-16 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17382023#comment-17382023 ] benj commented on DRILL-7740: - Le problème semble avoir été corrigé en version 1.19 {noformat} $ bash

[jira] [Commented] (DRILL-2388) support extract(epoch)

2021-06-24 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-2388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17368733#comment-17368733 ] benj commented on DRILL-2388: - It's painful to do {noformat} SELECT extract(hour FROM a) * 3600 +

[jira] [Created] (DRILL-7954) XML ability to not concatenate fields and attribute - change presentation of data

2021-06-22 Thread benj (Jira)
benj created DRILL-7954: --- Summary: XML ability to not concatenate fields and attribute - change presentation of data Key: DRILL-7954 URL: https://issues.apache.org/jira/browse/DRILL-7954 Project: Apache Drill

[jira] [Commented] (DRILL-4660) TextReader should support multibyte field delimiters

2020-06-05 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-4660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17126798#comment-17126798 ] benj commented on DRILL-4660: - Any news/progression/hope for this functionality ? > TextReader should

[jira] [Updated] (DRILL-7747) Function to determine Unknow fields / on fly generated missing fields

2020-06-04 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7747: Description: it would be really useful to have a function allowing to know if a field comes from an existing

[jira] [Updated] (DRILL-7747) Function to determine Unknow fields / on fly generated missing fields

2020-06-04 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7747: Description: it would be really useful to have a function allowing to know if a field comes from an existing

[jira] [Created] (DRILL-7747) Function to determine Unknow fields / on fly generated missing fields

2020-06-04 Thread benj (Jira)
benj created DRILL-7747: --- Summary: Function to determine Unknow fields / on fly generated missing fields Key: DRILL-7747 URL: https://issues.apache.org/jira/browse/DRILL-7747 Project: Apache Drill

[jira] [Commented] (DRILL-3014) Casting unknown field yields different result from casting null, and bad error message

2020-06-04 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17125847#comment-17125847 ] benj commented on DRILL-3014: - This problem seems to have been corrected (it's not possible to reproduce in

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

2020-05-20 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7104?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7104: Affects Version/s: 1.16.0 1.17.0 > Change of data type when parquet with multiple fragment

[jira] [Created] (DRILL-7740) LEAST and GREATEST does not work well with date in embedded mode

2020-05-18 Thread benj (Jira)
benj created DRILL-7740: --- Summary: LEAST and GREATEST does not work well with date in embedded mode Key: DRILL-7740 URL: https://issues.apache.org/jira/browse/DRILL-7740 Project: Apache Drill Issue

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

2020-03-30 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.17.0 > TO_CHAR does not seems work well depends on LOCALE >

[jira] [Comment Edited] (DRILL-1755) Add support for arrays and scalars as first level elements in JSON files

2020-03-25 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17066614#comment-17066614 ] benj edited comment on DRILL-1755 at 3/25/20, 11:19 AM: The problem appears to

[jira] [Commented] (DRILL-1755) Add support for arrays and scalars as first level elements in JSON files

2020-03-25 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17066614#comment-17066614 ] benj commented on DRILL-1755: - The problem appears to have been corrected in 1.17 The error shown previously

[jira] [Updated] (DRILL-7602) Possibility to force repartition on read/select

2020-03-24 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7602: Description: It will be nice and usefull in certain situations to have the capacity to do repartition like in

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

2020-03-12 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16927527#comment-16927527 ] benj edited comment on DRILL-7371 at 3/12/20, 4:19 PM: --- [~volodymyr], the problem

[jira] [Created] (DRILL-7602) Possibility to force repartition on read/select

2020-02-25 Thread benj (Jira)
benj created DRILL-7602: --- Summary: Possibility to force repartition on read/select Key: DRILL-7602 URL: https://issues.apache.org/jira/browse/DRILL-7602 Project: Apache Drill Issue Type: Improvement

[jira] [Updated] (DRILL-7595) Change of data type from bigint to int when parquet with multiple fragment

2020-02-20 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7595?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7595: Description: like on DRILL-7104, there is a bug that change the type from BIGINT to INT where a parquet have

[jira] [Commented] (DRILL-7595) Change of data type from bigint to int when parquet with multiple fragment

2020-02-20 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17040919#comment-17040919 ] benj commented on DRILL-7595: - Another trick to avoid the problem (use a substract between 2 egal value that

[jira] [Created] (DRILL-7595) Change of data type from bigint to int when parquet with multiple fragment

2020-02-20 Thread benj (Jira)
benj created DRILL-7595: --- Summary: Change of data type from bigint to int when parquet with multiple fragment Key: DRILL-7595 URL: https://issues.apache.org/jira/browse/DRILL-7595 Project: Apache Drill

[jira] [Commented] (DRILL-7588) Function TABLE + option lineDelimiter = '\r\n' eats sometime first char of a row

2020-02-20 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17040793#comment-17040793 ] benj commented on DRILL-7588: - As another possible solution: In the case of windows file with \r\n EOL, it's

[jira] [Commented] (DRILL-6096) Provide mechanisms to specify field delimiters and quoted text for TextRecordWriter

2020-02-17 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-6096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038357#comment-17038357 ] benj commented on DRILL-6096: - Just trying to use this new functionality. Some points (tested in 1.17 and

[jira] [Updated] (DRILL-7588) Function TABLE + option lineDelimiter = '\r\n' eats sometime first char of a row

2020-02-14 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7588: Description: With a TSV file ([#demo.tsv.gz] in attachment) generated on _Windows_ (EOL = \r\n). The file

[jira] [Created] (DRILL-7588) Function TABLE + option lineDelimiter = '\r\n' eats sometime first char of a row

2020-02-14 Thread benj (Jira)
benj created DRILL-7588: --- Summary: Function TABLE + option lineDelimiter = '\r\n' eats sometime first char of a row Key: DRILL-7588 URL: https://issues.apache.org/jira/browse/DRILL-7588 Project: Apache Drill

[jira] [Created] (DRILL-7569) dir0 problem reader - when path with wilcard and column named dir0

2020-02-05 Thread benj (Jira)
benj created DRILL-7569: --- Summary: dir0 problem reader - when path with wilcard and column named dir0 Key: DRILL-7569 URL: https://issues.apache.org/jira/browse/DRILL-7569 Project: Apache Drill Issue

[jira] [Created] (DRILL-7568) Strange renaming of duplicate column name

2020-02-05 Thread benj (Jira)
benj created DRILL-7568: --- Summary: Strange renaming of duplicate column name Key: DRILL-7568 URL: https://issues.apache.org/jira/browse/DRILL-7568 Project: Apache Drill Issue Type: Bug Affects

[jira] [Comment Edited] (DRILL-7449) memory leak parse_url function

2020-01-28 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17014216#comment-17014216 ] benj edited comment on DRILL-7449 at 1/28/20 11:28 AM: --- I have had a full check and

[jira] [Commented] (DRILL-7449) memory leak parse_url function

2020-01-20 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17019540#comment-17019540 ] benj commented on DRILL-7449: - [~arina], I would like but it's not possible, it's not a problem of size but a

[jira] [Commented] (DRILL-7449) memory leak parse_url function

2020-01-20 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17019508#comment-17019508 ] benj commented on DRILL-7449: - Hi [~IhorHuzenko] I realized that the problem may from input passed to

[jira] [Commented] (DRILL-7539) Aggregate expression is illegal in GROUP BY clause

2020-01-20 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17019310#comment-17019310 ] benj commented on DRILL-7539: - Please note that is also possible to bypass the problem with fully prefixing

[jira] [Created] (DRILL-7539) Aggregate expression is illegal in GROUP BY clause

2020-01-20 Thread benj (Jira)
benj created DRILL-7539: --- Summary: Aggregate expression is illegal in GROUP BY clause Key: DRILL-7539 URL: https://issues.apache.org/jira/browse/DRILL-7539 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-7449) memory leak parse_url function

2020-01-16 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016797#comment-17016797 ] benj commented on DRILL-7449: - hi [~IhorHuzenko], I have enable debug logging and the result is here: 

[jira] [Updated] (DRILL-7449) memory leak parse_url function

2020-01-16 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7449: Attachment: embedded_sqlline_with_enable_debug_logging.log.txt > memory leak parse_url function >

[jira] [Comment Edited] (DRILL-7449) memory leak parse_url function

2020-01-15 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016064#comment-17016064 ] benj edited comment on DRILL-7449 at 1/15/20 3:07 PM: -- [~IhorHuzenko], please find

[jira] [Commented] (DRILL-7449) memory leak parse_url function

2020-01-15 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016064#comment-17016064 ] benj commented on DRILL-7449: - [~IhorHuzenko], please find in attachment (execution with leak from my local

[jira] [Updated] (DRILL-7449) memory leak parse_url function

2020-01-15 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7449: Attachment: embedded_sqlline.log.txt embedded_FullJsonProfile.txt > memory leak parse_url function

[jira] [Commented] (DRILL-7449) memory leak parse_url function

2020-01-14 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17014960#comment-17014960 ] benj commented on DRILL-7449: - Hi [~IhorHuzenko] The problem doesn't appears for each run. Sometimes (with

[jira] [Created] (DRILL-7524) Distinct on array with any_value

2020-01-13 Thread benj (Jira)
benj created DRILL-7524: --- Summary: Distinct on array with any_value Key: DRILL-7524 URL: https://issues.apache.org/jira/browse/DRILL-7524 Project: Apache Drill Issue Type: Bug Components:

[jira] [Commented] (DRILL-7449) memory leak parse_url function

2020-01-13 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17014216#comment-17014216 ] benj commented on DRILL-7449: - I have had a full check and in reality we havn't used the drill-url-tools

[jira] [Updated] (DRILL-7519) Error on case when different branche are array of same type but build differenlty

2020-01-10 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7519: Attachment: full_log_DRILL7519.log > Error on case when different branche are array of same type but build >

[jira] [Commented] (DRILL-7449) memory leak parse_url function

2020-01-10 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17012874#comment-17012874 ] benj commented on DRILL-7449: - In the meantime and if it can helps someone I have found this page

[jira] [Created] (DRILL-7519) Error on case when different branche are array of same type but build differenlty

2020-01-08 Thread benj (Jira)
benj created DRILL-7519: --- Summary: Error on case when different branche are array of same type but build differenlty Key: DRILL-7519 URL: https://issues.apache.org/jira/browse/DRILL-7519 Project: Apache Drill

[jira] [Created] (DRILL-7516) count(*) on empty JSON produce nothing

2020-01-07 Thread benj (Jira)
benj created DRILL-7516: --- Summary: count(*) on empty JSON produce nothing Key: DRILL-7516 URL: https://issues.apache.org/jira/browse/DRILL-7516 Project: Apache Drill Issue Type: Bug

[jira] [Created] (DRILL-7515) ORDER BY clause produce error on GROUP BY with array field manager with any_value

2020-01-07 Thread benj (Jira)
benj created DRILL-7515: --- Summary: ORDER BY clause produce error on GROUP BY with array field manager with any_value Key: DRILL-7515 URL: https://issues.apache.org/jira/browse/DRILL-7515 Project: Apache Drill

[jira] [Created] (DRILL-7493) convert_fromJSON and unicode

2019-12-20 Thread benj (Jira)
benj created DRILL-7493: --- Summary: convert_fromJSON and unicode Key: DRILL-7493 URL: https://issues.apache.org/jira/browse/DRILL-7493 Project: Apache Drill Issue Type: Bug Components:

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

2019-11-29 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-6963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985067#comment-16985067 ] benj commented on DRILL-6963: - For the second point (arry_agg), in attempt of an eventual official function,

[jira] [Commented] (DRILL-1755) Add support for arrays and scalars as first level elements in JSON files

2019-11-26 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982491#comment-16982491 ] benj commented on DRILL-1755: - This problems seems partially OK, With a file containing the previous

[jira] [Created] (DRILL-7452) Support comparison operator for Array

2019-11-21 Thread benj (Jira)
benj created DRILL-7452: --- Summary: Support comparison operator for Array Key: DRILL-7452 URL: https://issues.apache.org/jira/browse/DRILL-7452 Project: Apache Drill Issue Type: Wish

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

2019-11-21 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7379: Description: sample file: [^example.parquet] With data as: {code:sql} SELECT id, tags FROM `example_parquet`;

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

2019-11-21 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7379: Attachment: example.parquet > Planning error > -- > > Key: DRILL-7379 >

[jira] [Created] (DRILL-7449) memory leak parse_url function

2019-11-18 Thread benj (Jira)
benj created DRILL-7449: --- Summary: memory leak parse_url function Key: DRILL-7449 URL: https://issues.apache.org/jira/browse/DRILL-7449 Project: Apache Drill Issue Type: Bug Components:

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

2019-11-15 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16975198#comment-16975198 ] benj commented on DRILL-7375: - Waiting for a possible official version of such a feature, it is possible to

[jira] [Updated] (DRILL-7444) JSON blank result on SELECT when too much byte in multiple files on Drill embedded

2019-11-14 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7444: Summary: JSON blank result on SELECT when too much byte in multiple files on Drill embedded (was: JSON blank

[jira] [Updated] (DRILL-7444) JSON blank result on SELECT when too much byte in multiple files on embedded

2019-11-14 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7444: Description: 2 files (a.json and b.json) and the concat of these 2 file (ab.json) produce different results on a

[jira] [Updated] (DRILL-7444) JSON blank result on SELECT when too much byte in multiple files on embedded

2019-11-14 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7444: Description: 2 files (a.json and b.json) and the concat of these 2 file (ab.json) produce different results on a

[jira] [Updated] (DRILL-7444) JSON blank result on SELECT when too much byte in multiple files

2019-11-14 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] benj updated DRILL-7444: Description: 2 files (a.json and b.json) and the concat of these 2 file (ab.json) produce different results on a

[jira] [Created] (DRILL-7444) JSON blank result on SELECT when too much byte in multiple files

2019-11-14 Thread benj (Jira)
benj created DRILL-7444: --- Summary: JSON blank result on SELECT when too much byte in multiple files Key: DRILL-7444 URL: https://issues.apache.org/jira/browse/DRILL-7444 Project: Apache Drill Issue

[jira] [Commented] (DRILL-7426) Json support lists of different types

2019-10-29 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16961802#comment-16961802 ] benj commented on DRILL-7426: - In my particular case schema is difficult to predict, but as [~cgivre] says,

[jira] [Created] (DRILL-7426) Json support lists of different types

2019-10-28 Thread benj (Jira)
benj created DRILL-7426: --- Summary: Json support lists of different types Key: DRILL-7426 URL: https://issues.apache.org/jira/browse/DRILL-7426 Project: Apache Drill Issue Type: Improvement

[jira] [Created] (DRILL-7420) window function improve ROWS clause/frame possibilities

2019-10-23 Thread benj (Jira)
benj created DRILL-7420: --- Summary: window function improve ROWS clause/frame possibilities Key: DRILL-7420 URL: https://issues.apache.org/jira/browse/DRILL-7420 Project: Apache Drill Issue Type: New

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

2019-10-22 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/DRILL-7017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16957093#comment-16957093 ] benj commented on DRILL-7017: - Not sure to understand because lz4 is already (by default) in

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

[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=16950784#comment-16950784 ] benj commented on DRILL-7291: - [~arina] you are right, with the option +store.parquet.use_new_reader+ the

[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=16949569#comment-16949569 ] benj commented on DRILL-7291: - Please find in attchment the error log [^sqlline_error.log] I was intrigued

[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=16949501#comment-16949501 ] benj commented on DRILL-7291: - Exactly done the same as you (see below), but obtain an "+Error:

[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=16947512#comment-16947512 ] benj edited comment on DRILL-7348 at 10/9/19 10:01 AM: --- I have tested in 1.15 and

[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=16947512#comment-16947512 ] benj commented on DRILL-7348: - I have tested in 1.15 and 1.16. I think thata the problem of [~snapdoodle] is

[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=16945871#comment-16945871 ] benj commented on DRILL-7291: - In fact, the problem appear in +embeded mode+ (bin/drill-embedded) and not in

[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=16945825#comment-16945825 ] benj commented on DRILL-7291: - Sure, sorry for the delay but I preferred to double check some points with the

[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] [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=16944585#comment-16944585 ] benj edited comment on DRILL-7291 at 10/7/19 9:55 AM: -- Indeed, surprisingly, I can't

[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=16944585#comment-16944585 ] benj edited comment on DRILL-7291 at 10/7/19 9:44 AM: -- Indeed, surprisingly, I can't

[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=16944585#comment-16944585 ] benj commented on DRILL-7291: - Indeed, surprisingly, I can't reproduce the problem with the file in

[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] [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] [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=16943152#comment-16943152 ] benj commented on DRILL-7004: - Ok, thanks for the precision. Note that in a suprising way, in the presented

[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=16942863#comment-16942863 ] benj commented on DRILL-7004: - Despite the parallelization, for a system containing several hundreds of

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

[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

[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=16935943#comment-16935943 ] benj commented on DRILL-6958: - In the next example, with a table with a column that contain a piece of json

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

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

[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] [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-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] [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] [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: Summary: DST/UTC cast/to_timestamp problem (was: DST/UTC problem) > DST/UTC cast/to_timestamp problem >

  1   2   >