Modify Stage

[eze_ke]

Hi

below id the code for one of my coulumn in modify stage
COL:timestamp=TimestampFromSecondsSince(COL)

converting integer to timestamp

is it correct???

as i am getting the following Fatal error

main_program: Error parsing modify adapter: Error in binding: Unknown conversion: TimestampFromSecondsSince
Expected destination field selector, got: ")"; input:
COL:timestamp=TimestampFromSecondsSince(COL)

and Job aborts

Thanks

[singhald]

Hi

use the current modify function for time stamp;

use the below function , it will solve your problem

COL:timestamp=timestamp_from_seconds_since(dfloat)

Deepak

[eze_ke]

Hi deepak,

i used the following derivation
COLumn:timestamp=Timestamp_From_Seconds_Since(COLumn)

but still i am getting the error

main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_seconds_since[*******************](dfloat)": APT_Conversion_TimeStamp_SecondsSince: Parameter [] does not parse as a timestamp
Expected destination field selector, got: ")"; input:

[ray.wurlod]

You don't use dfloat between the parentheses; you use the name of an input column. And it must be of type string (look at the name of the function again).

[eze_ke]

I am Using the following code in the specification

COLUMN:timestamp=timestamp_from_seconds_since(COLUMN)

Error what i get is:

"""""
main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_seconds_since[*******************](dfloat)": APT_Conversion_TimeStamp_SecondsSince: Parameter [] does not parse as a timestamp
Expected destination field selector, got: ")"; input:
TABLE_LOAD_END_DT:timestamp=timestamp_from_seconds_since(TABLE_LOAD_END_DT)
;
"""""

[chulett]

This is going nowhere. Start over. State the problem you are trying to solve. Include an example of your input data and what you think your output needs to be.

[eze_ke]

I have date comming from source, i want to take the min and max for date

i am changing the timestamp to secondssincefromtimestamp in the transformer then taking it into aggregator do min / max then take it to modify stage where iam using the following specification to chane it back to timestamp

COL:timestamp=timestamp_from_seconds_since(COl)


i am getting the following error

main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_seconds_since[*******************](dfloat)": APT_Conversion_TimeStamp_SecondsSince: Parameter [] does not parse as a timestamp
Expected destination field selector, got: ")"; input:
TABLE_LOAD_END_DT:timestamp=timestamp_from_seconds_since(TABLE_LOAD_END_DT)
;

please suggest