How to specify the files when creating external table?

Hi all, I want to create external tables, and the location should be a directory in HDFS. How could I specify several not all files in this directory to be stored into the table? Thanks. -- dujinhang

Re: Re: Hive create table

Thanks for all your help. I fix my problem by editing the hive-site.xml. hive.aux.jars.path file:///usr/lib/hive/lib/hive-contrib-0.7.0-CDH3B4.jar These JAR file are available to all users for all jobs Now, I want to understand the "input.regex" . Is this Java regular expression? Thanks