TODO before integration

[vserret]

Simple integration (we only reuse the schema)

• Visitor for converting qrlew Schema to proto Schema : ½ - 1 day

Complete integration

• Conversion SqlParser::Query -> Relation :

• HAVING,

• DISTINCT, (1 week)

• COUNT(*), (2 days)

• CAST

• TABLESAMPLE (1 day): ** Not supported by sqlparser**

• Alias and names with ‘“‘ (2 days) #234

• String functions: upper, lower, concat, coalesce, trim, substring, substr, position, char_lengh, encode, decode, unhex, regexp_contains, regexp_extract, regexp_substr, regexp_replace (2 days)

• Date functions: CURRENT_DATE | CURRENT_TIME | CURRENT_TIMESTAMP, EXTRACT, DAYNAME, FROM_UNIXTIME, UNIX_TIMESTAMP, DATE_FORMAT, QUARTER, DOW, DATETIME_DIFF, DATEPART, DATE (2 days)

• Mathematical functions : abs, ceil, ceiling, floor, sign, sqrt, square, exp, ln, log, log10, log2, sin, cos, tan, asin, acos, atan, atanh, degrees, pi, random, rand, newid, round, power (2 days)

• Boolean expressions

• Truncate functions : trunc, truncate (1 day)

• Translator

• Function for finding table names #235

• Function for renaming tables

• split quotes function

• ValidQueryRewriter (aliasing the columns, add some columns in the SELECT … ) #232

• Merge with synthetic result #233

• DP compilation:

• problem with when the peid is not a string (Could be resolved by implementing CAST)

• DP estimators for : AVG, VARIANCE, STDDEV (2 days)

• Automatic bounding ?