Can you post the errors?
On Mon, Apr 22, 2013 at 5:22 PM, Raj hadoop wrote:
> Hi,
>
> Thanks for giving reply. I didn't have any issues with load statement as i
> have mentioned the correct file path while loading. Could you please check
> the rest of the logic..
>
>
>
> On Tue, Apr 23, 2013 at
Hi,
Thanks for giving reply. I didn't have any issues with load statement as i
have mentioned the correct file path while loading. Could you please check
the rest of the logic..
On Tue, Apr 23, 2013 at 2:33 AM, j.barrett Strausser <
j.barrett.straus...@gmail.com> wrote:
> You'll have more luck
You'll have more luck if you post the errors.
Off the bat, I assume you are going to have problems given your load
statement.
-b
On Mon, Apr 22, 2013 at 4:59 PM, Raj hadoop wrote:
> Hi friends,
>
> I am new to PIG script. I need to convert below sql query to PIG script.
>
>
> SELECT ('CSS'||D
Hi friends,
I am new to PIG script. I need to convert below sql query to PIG script.
SELECT ('CSS'||DB.DISTRICT_CODE||DB.BILLING_ACCOUNT_NO) BAC_KEY,
CASE WHEN T1.TAC_142 IS NULL THEN 'N' ELSE T1.TAC_142 END TAC_142 FROM
(
SELECT DISTRICT_CODE,BILLING_ACCOUNT_NO,
MAX(CASE WHEN TAC_1 = 'Y'