Re: Select dynamically a partition in an external table

2012-09-10 Thread Etienne Dumoulin
Hi, I think there is a bug for selecting partitions dynamically. There is no problem for sequence file tables. However for textfile tables it seems to not query it in the same way. In the logs there is no mapper assigned, see end of this mail, the first log is for a SEQUENCEFILE storage hive table

Select dynamically a partition in an external table

2012-09-07 Thread Etienne Dumoulin
Hi, I have an external table partitioned per day, I have currently one partition. When I launch: SELECT max(day) from MY_EXTERNAL_TABLE GROUP BY DAY; It returns nothing. I would like to use this query to select a partition dynamically: SELECT ID, PROPERTY FROM MY_EXTERN