I am not familiar with SQL queries but the first thing I would try is to
separate the Query with quotes

 select "node_name, volume_name from volumeusage" > /adsmlogs/output.file

Or something to that effect.  I think looking at documentation on the select
statement should help to better answer your question.