Page 1 of 1

Expand Stage Schema

Posted: Tue Oct 05, 2010 11:26 am
by kpsita
Hi,
I am using Compress stage to compress a dataset. then when I use Expand to uncompress the compressed dataset it gives me some schema error. I went through the document and found that while using expand satge to uncompress, I should be using the compressed schema in the field layouts. How can I get the schema of a compressed file.

Thanks,

Posted: Tue Oct 05, 2010 3:44 pm
by ray.wurlod
Save it from the Columns tab of the Compress stage output link?

Posted: Tue Oct 05, 2010 4:21 pm
by kpsita
I tried, but giving me the same error. The error is
When binding output schema variable "outRec": Cannot drop the case from tagged output; case "t.encoded".

here is my job design (JOB1) to Compress
Dataset1.ds ---------> Compress --------------->Dataset2.ds
field1(varchar1) field1(varchar1)
field2(varchar10) field2(varchar10)

JOB2 to Expand
Dataset2.ds ---------> Expand --------------->Dataset3.ds
field1(varchar1) field1(varchar1)
field2(varchar10) field2(varchar10)

Is my job design correct?

Thanks

Posted: Wed Oct 06, 2010 3:44 am
by agpt
Is the schema on Dataset2.ds is same as input as in your example it looks exactly the same.

Posted: Wed Oct 06, 2010 9:55 am
by kpsita
Yes, the schema is same for Input and output files. is it correct or do i have to mention a different schema for compressed dataset.

thanks

Posted: Fri May 16, 2014 3:30 am
by sendmkpk
hi,

Can some answer this question now, i am facing same problem not able to read dataset with same schema as compressed