title: Vertica LISTAGG not defined
body: <p>As far as I can tell from the <a href="https://www.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Aggregate/LISTAGG.htm%3FTocPath%3DSQL%2520Reference%2520Manual%7CSQL%2520Functions%7CAggregate%2520Functions%7C_____20" rel="nofollow noreferrer">Vertica 8.1.x docs</a> LISTAGG is supported for versions of Vertica 8.1.x and up; however, when I try to use this function I am seeing the following:</p>
  
  <blockquote>
    <p>SQL Error [3457] [42883]: [Vertica]VJDBC ERROR: Function
    LISTAGG(varchar) does not exist, or permission is denied for
    LISTAGG(varchar)</p>
  </blockquote>
  
  <p>While executing: </p>
  
  <pre><code>SELECT LISTAGG(myColumn) FROM myTable;
  </code></pre>
  
  <p>I saw in another Stack Overflow post that LISTAGG was introduced in v9.1 <a href="https://stackoverflow.com/questions/45951892/listagg-in-vertica">(see here)</a>. I am currently using version v9.0.1-19</p>
  
  <p><strong>Can anyone confirm or provide insight as to why LISTAGG might not be working?</strong></p>