Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Can hive show external table filenames?


+
Keith Wiley 2013-01-31, 19:37
+
Edward Capriolo 2013-01-31, 20:12
+
Keith Wiley 2013-01-31, 21:55
+
Edward Capriolo 2013-01-31, 22:38
Copy link to this message
-
Re: Can hive show external table filenames?
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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     [EMAIL PROTECTED]     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
________________________________________________________________________________
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB