[REVIEW] Support for DURATION type

Christian8491 commented 3 years ago

This PR closes #1467. This one is related to BlazingDB/blazingsql-testing-files#29 PR which adds INTERVAL tests.

This PR enables the use of many INTERVAL sql operations like:

sql1 = "select duration_col + INTERVAL '1' SECOND, duration_col - INTERVAL '1' HOUR from interval_table" sql2 = "select INTERVAL '125 10' DAY(3) TO HOUR from interval_table" sql3 = "select duration_col + INTERVAL '2 01:03:10' DAY TO SECOND from interval_table"

Due to the large range of DURATION/INTERVAL sql queries, I just have tested some of them, you can check this list of enabled queries from the intervalTest.py file.

This PR does not enables DURATION type for data_parsers as they are still experimental and some new e2e test should be provided also.

Sql operatios over MONTH and YEAR (with DURATION type) are currently not supported (SECOND, MINUTE, HOUR, DAY are) .

GPUtester commented 3 years ago

Please update the changelog in order to start CI tests.

View the gpuCI docs here.

Christian8491 commented 3 years ago

rerun tests

Christian8491 commented 3 years ago

rerun tests

Christian8491 commented 3 years ago

rerun tests

Christian8491 commented 3 years ago

rerun tests

Christian8491 commented 3 years ago

@williamBlazing could you reopen this PR pointing to the "new" branch-21.06

Christian8491 commented 3 years ago

rerun tests

Christian8491 commented 3 years ago

rerun tests

BlazingDB / blazingsql

[REVIEW] Support for DURATION type #1523