Re: Can hive show external table filenames?

[Keith Wiley <kw...@keithwiley.com>]

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 <kw...@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 <kw...@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     kwiley@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
________________________________________________________________________________