Thanks, that seems like a reasonable summary of my options. Cheers!
On Jan 31, 2013, at 14:38 , Edward Capriolo wrote: > You can execute dfs commands from inside hive > > hive>dfs -ls > > You can also use virtual columns inside a select > > https://cwiki.apache.org/Hive/languagemanual-virtualcolumns.html > > However there is no direct command in hive to list the files in a > table/partition. > > On Thu, Jan 31, 2013 at 4:55 PM, Keith Wiley <kwi...@keithwiley.com> wrote: >> Hmmm, that doesn't seem to list the files in the directory. >> >> On Jan 31, 2013, at 12:12 , Edward Capriolo wrote: >> >>> Try >>> describe extended <tablename> >>> or >>> describe extended <tablename> (<partition>) >>> >>> the location is one of the properties >>> >>> Edward >>> >>> >>> On Thu, Jan 31, 2013 at 2:37 PM, Keith Wiley <kwi...@keithwiley.com> wrote: >>>> "show tables" shows the HDFS directories which correspond to Hive tables >>>> and various select queries show data from inside the files (each row of a >>>> file being a row of the overarching table that the entire directory >>>> represents)...or so I have convinced myself...but can Hive show the HDFS >>>> filenames? Or is "hadoop fs -ls" the only way to do that? >>>> >>>> Thanks. ________________________________________________________________________________ Keith Wiley kwi...@keithwiley.com keithwiley.com music.keithwiley.com "Yet mark his perfect self-contentment, and hence learn his lesson, that to be self-contented is to be vile and ignorant, and that to aspire is better than to be blindly and impotently happy." -- Edwin A. Abbott, Flatland ________________________________________________________________________________
