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 - Drill, SQL Parser Affects Versions: 1.15.0 Reporter: benj
In other SQL tools (ex postgres) exists composite type. In a useful way it's possible to concat quickly all the column of a table in a single string {code:java} SELECT (c.*)::text FROM mytable c {code} It's useful where ignore the content of columns to have the ability to regex all the field at the same time in a simple request, example : {code:java} SELECT * FROM mytable c WHERE (c.*)::text LIKE '%mysearch%' LIMIT 3; {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)