Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> Declaring schema for unknown number of columns

Copy link to this message
Re: Declaring schema for unknown number of columns
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