ahh. we got ourselves a bona-fide head banger.  Welcome to the club!! :)

    a.col1 as foo,
    a.col2 as bar,
    a.col3 as baz

    database1.table1 a
    INNER JOIN database2.table2 b on a.col1 = b.col1

    a.year = 2014
    and a.month = 1
    and a.day = 20
so lose the 'AS' for the table alias but keep it for the column alias.  see
what happens.

Also, good to tell us what version of Hive you're running 'cuz there's a
few out there.

On Thu, Feb 6, 2014 at 4:26 PM, Oliver Keyes <[EMAIL PROTECTED]> wrote:
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