Re: How to convert Int to Date

2020-11-18 Thread Rex Fenley
Looks like using a cast from INT to DATE worked out just fine. Thanks! On Tue, Nov 17, 2020 at 6:39 AM Timo Walther wrote: > Hi Rex, > > the classes mentioned in the documentation such as `int` and > `java.lang.Integer` are only used when you leave the SQL world to a UDF > or to a Java implemen

Re: How to convert Int to Date

2020-11-17 Thread Timo Walther
Hi Rex, the classes mentioned in the documentation such as `int` and `java.lang.Integer` are only used when you leave the SQL world to a UDF or to a Java implementation in a sink. But as a SQL user you only need to pay attention to the logical data type. Those must match entirely or be a sup

Re: How to convert Int to Date

2020-11-17 Thread Khachatryan Roman
Hello, Do both of the types you use have the same nullability? For a primitive int, the documentation you referred to says: "Output only if type is not nullable". Regards, Roman On Tue, Nov 17, 2020 at 7:49 AM Rex Fenley wrote: > Hello, > > I'm using the Table API and I have a column which is

How to convert Int to Date

2020-11-16 Thread Rex Fenley
Hello, I'm using the Table API and I have a column which is an integer day since epoch. According to the docs [1] both `int` and `java.lang.Integer` are acceptable for DATE. However, if I try to use the SQL API to write a DATE out to the Elasticsearch connector for the INT column I receive an exce