Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to use record time basis(type convert) in Hadoop FS Output Files Directory Template

I have trouble with making a directory using record:value time basis in Hadoop FS Record time column is character type like '20190619160631'

I set up Time Basis : ${record:value("/date_info")} Directory Template : /user/hhiwedas/raw/${YYYY()}-${MM()}-${DD()}

It's running but happens error like 'CTRCMN_0100 - Error evaluating expression ${record:value("/date_info")}: javax.servlet.jsp.el.ELException: Attempt to convert String "20190619160631" to type "java.util.Date", but there is no PropertyEditor for that type'

So I want to know how to convert string type to appropriate type Hope your fast response

Thanks,

How to use record time basis(type convert) in Hadoop FS Output Files Directory Templatepath config. on record value time basis

I have trouble with making a directory using record:value time basis in Hadoop FS Record time column is character type like '20190619160631'

I set up Time Basis : ${record:value("/date_info")} Directory Template : /user/hhiwedas/raw/${YYYY()}-${MM()}-${DD()}

It's running but happens error like like

'CTRCMN_0100 - Error evaluating expression ${record:value("/date_info")}: javax.servlet.jsp.el.ELException: Attempt to convert String "20190619160631" to type "java.util.Date", but there is no PropertyEditor for that type'

type'

So I want to know how to convert string type to appropriate type Hope your fast response

Thanks,

Hadoop FS Directory path config. on record value time basis

I have trouble with making a directory using record:value time basis in Hadoop FS Record time column is character type like '20190619160631'

I set up up

  • Time Basis : : ${record:value("/date_info")}
  • Directory Template : : /user/hhiwedas/raw/${YYYY()}-${MM()}-${DD()}

It's running but happens error like

'CTRCMN_0100 - Error evaluating expression ${record:value("/date_info")}: javax.servlet.jsp.el.ELException: Attempt to convert String "20190619160631" to type "java.util.Date", but there is no PropertyEditor for that type'

So I want to know how to convert string type to appropriate type Hope your fast response

Thanks,

Hadoop FS Directory path config. on record value time basis

I make JDBC Query Consumer to Hadoop FS pipeline and I have trouble with processing string type time in the pipeline

1st Question : SQL Query on JDBC Query Consumer

Database is postgresql and I want to use incremental mode for ingestion date_info column type is character varying like '20190601000000'

SQL Query: SELECT * FROM TWEDAS_RAW_DATA WHERE date_info > '${OFFSET}' ORDER BY date_info Initial Offset: 20190601000000 Offset Column: date_info

2nd Question : Directory Template making a directory template using record:value time basis in Hadoop FS Record time column is character type like '20190619160631'

I set upFS

  • Time Basis : ${record:value("/date_info")}

  • Directory Template : /user/hhiwedas/raw/${YYYY()}-${MM()}-${DD()}

It's running but happens error like

like
'CTRCMN_0100 - Error evaluating expression ${record:value("/date_info")}: javax.servlet.jsp.el.ELException: Attempt to convert String "20190619160631" to type "java.util.Date", but there is no PropertyEditor for that type'
type'

So I want to know how to convert string type to appropriate type Hope your fast response

Thanks,

Hadoop FS Directory path config. on record value time basis

I make JDBC Query Consumer to Hadoop FS pipeline and I have trouble with processing string type time in the pipeline

1st Question : SQL Query on JDBC Query Consumer

Database is postgresql and I want to use incremental mode for ingestion date_info column type is character varying like '20190601000000'

SQL Query: SELECT * FROM TWEDAS_RAW_DATA WHERE date_info > '${OFFSET}' ORDER BY date_info Initial Offset: 20190601000000 Offset Column: date_info

2nd Question : Directory Template making a directory template using record:value time basis in Hadoop FS

  • Time Basis : ${record:value("/date_info")}

  • Directory Template : /user/hhiwedas/raw/${YYYY()}-${MM()}-${DD()}

It's running but happens error like 'CTRCMN_0100 - Error evaluating expression ${record:value("/date_info")}: javax.servlet.jsp.el.ELException: Attempt to convert String "20190619160631" to type "java.util.Date", but there is no PropertyEditor for that type'

So I want to know how to convert string type to appropriate type Hope your fast response

Thanks,

Hadoop FS Directory path config. on record value time basis[JDBC Query Consumer to Hadoop FS] string type process in sql query and Hadoop directory path

I make JDBC Query Consumer to Hadoop FS pipeline and I have trouble with processing string type time in the pipeline

1st Question : SQL Query on JDBC Query Consumer

Database is postgresql and I want to use incremental mode for ingestion date_info column type is character varying like '20190601000000'

SQL Query: SELECT * FROM TWEDAS_RAW_DATA WHERE date_info > '${OFFSET}' ORDER BY date_info Initial Offset: 20190601000000 Offset Column: date_info

2nd Question : Directory Template making a directory template using record:value time basis in Hadoop FS

  • Time Basis : ${record:value("/date_info")}

  • Directory Template : /user/hhiwedas/raw/${YYYY()}-${MM()}-${DD()}

It's running but happens error like 'CTRCMN_0100 - Error evaluating expression ${record:value("/date_info")}: javax.servlet.jsp.el.ELException: Attempt to convert String "20190619160631" to type "java.util.Date", but there is no PropertyEditor for that type'

So I want to know how to convert string type to appropriate type Hope your fast response

Thanks,

[JDBC Query Consumer to Hadoop FS] string type process date processing in sql query and Hadoop directory path

I make JDBC Query Consumer to Hadoop FS pipeline and I have trouble with processing string type time in the pipeline

1st Question : SQL Query on JDBC Query Consumer

Database is postgresql and I want to use incremental mode for ingestion date_info column type is character varying like '20190601000000'

SQL Query: SELECT * FROM TWEDAS_RAW_DATA WHERE date_info > '${OFFSET}' ORDER BY date_info Initial Offset: 20190601000000 Offset Column: date_info

2nd Question : Directory Template making a directory template using record:value time basis in Hadoop FS

  • Time Basis : ${record:value("/date_info")}

  • Directory Template : /user/hhiwedas/raw/${YYYY()}-${MM()}-${DD()}

It's running but happens error like 'CTRCMN_0100 - Error evaluating expression ${record:value("/date_info")}: javax.servlet.jsp.el.ELException: Attempt to convert String "20190619160631" to type "java.util.Date", but there is no PropertyEditor for that type'

So I want to know how to convert string type to appropriate type type

Hope your fast response

Thanks,