how to get hdfs filename with apache drill

Question

I want to get hdfs filename through drill to show, the apache drill user guide(https://drill.apache.org/docs/file-system-storage-plugin/) not written how to get it, I need help

Please make sure you read this and try to improve your question: stackoverflow.com/help/mcve — Thiago Sá
are you able to add hdfs plugin as mentioned in the drill user guide? — Dev

user6294073 user6294073 · Accepted Answer · 2016-05-05T05:51:56

You can use this command

SHOW FILES [ FROM filesystem.directory_name | IN filesystem.directory_name ];