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
