Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7003

aggregate all columns

    XMLWordPrintableJSON

    Details

    • Type: Wish
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.15.0
    • Fix Version/s: None
    • Labels:
      None

      Description

      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

      SELECT (c.*)::text FROM mytable c
      

      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 :

      SELECT * FROM mytable c WHERE (c.*)::text LIKE '%mysearch%' LIMIT 3;
      

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              benj641 benj
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: