SQL SUBSTR function support


#1

Does MapD support SQL SUBSTR function? I would like to do something like this via SQL SUBSTR function,

SELECT CODE, SUM(POP)
FROM
(SELECT SUBSTR(continent,1,2) as CODE, SUM(population) as POP
FROM world
GROUP BY continent) t
GROUP By CODE

Thanks

Frank


#2

Hi @fxia99,

Thanks for your question.

We currently do not support SUBSTR, but likely will in the future. You might consider running the SUBSTR at ETL if you have a fixed pattern you would like to extract.


#3

@darwin
Thank you for your quick response! I am researching GPU based SQL databases, to be able to take advantage of a GPU database, the use case I mentioned in the question is critical for us.

Frank