If you can load it but join operation need the complete schema, then you
can try do a generate statement to project your original relation to
produce the one you can define schema for all fields.
On Mon, Jan 7, 2013 at 2:19 PM, Chan, Tim <[EMAIL PROTECTED]> wrote:
> Is it possible to declare a schema when doing a LOAD for data in which you
> do not know the total number of columns?
> For instance. I know the data contains 6 or more columns. These columns are
> of the same data type.
> I basically want to join this data with another data set, but I was getting
> the following error:
> ERROR 1109: Input (six_month_and_variable_month_sales) on which outer
> join is desired should have a valid schema
-- Jinyuan (Jack) Zhou