Aginity Script

Alan Beattie

• October 15, 2019 11:36

I'm using aginity script to execute to file, but column headers are not included in the results. Is it possible to include them?

0

• Official comment

  

  Sergey Polshvedkin

  • October 15, 2019 14:21
  • Edited

  Hi Alan,

   

  That`s correct - there is no possibility to write the header now.

  This feature is in our backlog already.

  Cannot say when it appears in the product but we release a new version every 2 weeks.

  So, keep using the product and don`t miss new updates and one day this feature will be there.

   

   

  Comment actions Permalink
• 

  Sergey Polshvedkin

  • October 15, 2019 11:57

  Hello Alan,

   

  Could you please provide some details like a version of product, the platform you are trying to connect and actually a script, if possible?

   

  Regards,

  Sergey

   

  0

  Comment actions Permalink
• 

  Alan Beattie

  • October 15, 2019 12:11

  Hi Sergey,

  Using Aginity Pro 0.17.281

  Greenplum connection

   

  Example script is:

  #+sql

  :output file

  :path 'c:/users/alan/desktop/backlog_list'

  :delimiter ','

  :null_value 'NULL'

  :quote_char '"'

  :overwrite true

   

  #+begin

  SELECT

      i.pyid , substring(i.workbasket,1,2) as market , i.workbasket , i.pyfrom , i.pyto

  
  

  FROM

  interaction_main i

  
  

  WHERE

  i.pystatuswork = 'Open' and substring(i.pyid,1,2) = 'I-' and substring(i.workbasket,1,2) is not NULL and substring(i.workbasket,1,2) <> 'TX'

  
  

  ORDERBY

  market, i.workbasket, i.pyfrom

  ;

  #+END

   

  0

  Comment actions Permalink
• 

  Jonathan Sabah

  • November 15, 2019 17:00

  Hi Jeff Schlitt,

   

  Coud you please update the documentation https://aginity-documentation.readthedocs.io/projects/aginity-pro/en/latest/docs/Query_Panel/using_panel/#executing-to-a-file to include the ability to add the column headers, and how to compress to Zip?

  Thanks

  Jonathan

  1

  Comment actions Permalink

Please sign in to leave a comment.