Can any one help me what is the sentx to get data in .xlsx format thru vql.
Why don`t you create an ODBC connection to your Vertica database and then connect form Excel to your db !
I need to create a cron job (In Linux) and send that output to users.
Here is some idea that might work for you.
- export the content of the data into csv format, any separetor would work.
- here i use | , the trick is the "sep=|" (it tell what is your delimiter)make sure you have this as the first line of the file, so when they open it in excel all should be aligned.
vsql -U dbadmin -w password -F $'|' -At -c "SELECT * FROM table_name" > '/tmp/bla.csv'sed -i '1s/^/sep=|\n/' /tmp/bla.csv
The sed command will add the delimiter as the first line in the file.
This should do the trick .
Happy to hear this helped .
You might wanna cleanup the last row of the files since is going to show the number of rows.