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

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 Compone

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

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] [Created] (DRILL-7747) Function to determine Unknow fields / on fly generated missing fields

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 Iss

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

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 Ty

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

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] [Created] (DRILL-7595) Change of data type from bigint to int when parquet with multiple fragment

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] [Created] (DRILL-7588) Function TABLE + option lineDelimiter = '\r\n' eats sometime first char of a row

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

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

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 Vers

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

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] [Created] (DRILL-7524) Distinct on array with any_value

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

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

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

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 Component

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

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

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

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

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 Component

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

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

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

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 T

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

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 Co

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

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 Fe

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

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-7396) Exception when trying to access last element of an array with repeated_count

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

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-7392) Exclude some files when requesting directory

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

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-7389) JSON empty list avoid Parquet creation

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-7379) Planning error

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

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-7375) composite type map cast/convert_to

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] [Created] (DRILL-7371) DST/UTC problem

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] [Created] (DRILL-7321) split function doesn't work without from

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] [Created] (DRILL-7319) Option to request NOT NULL column as NULLABLE column

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-7291) parquet with compression gzip doesn't work well

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] [Created] (DRILL-7288) IndexOutOfBoundsException when coalesce(dir0,'')

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] [Created] (DRILL-7265) Cast/To_type with on error handling

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] [Created] (DRILL-7260) Error on clause that should not be evaluated

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] [Created] (DRILL-7247) Use result of DESCRIBE as a SELECT

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] [Created] (DRILL-7246) DESCRIBE on Parquet File

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-7243) Storage Plugins Management

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-7219) Ignore hidden file problems

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-7175) Configuration of store.parquet.use_new_reader in drill-override.conf has no effect

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-7131) generate_series / generator

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] [Created] (DRILL-7104) Change of data type when parquet with multiple fragment

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] [Created] (DRILL-7090) Improve management of Optional(Nullable) / Required(Not nullable) type at least for parquet storage

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] [Created] (DRILL-7020) big varchar doesn't work with extractHeader=true

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] [Created] (DRILL-7017) lz4 codec for (un)compression

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

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

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

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

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

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

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 A

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

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

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

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] [Created] (DRILL-6984) from table escape parameter not deleted when defined with value other than '"'

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] [Created] (DRILL-6981) command line option to choose/force drill-override.conf

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-6980) --run regression - error when empty line or command at end of the file

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 Is

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

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

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

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] [Created] (DRILL-6974) SET/SHOW

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 Affe

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

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 D

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

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

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

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] [Created] (DRILL-6958) CTAS csv with option

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-6954) ADDRESS_COUNT doesn't work anymore

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-6948) Defaults values not homogeneous

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-6943) SELECT n time the same field in json

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] [Created] (DRILL-6940) CTAS partition parquet file with non existant columns

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