You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "benj (JIRA)" <ji...@apache.org> on 2019/01/25 09:38:00 UTC
[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 - 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)