From user-return-33398-archive-asf-public=cust-asf.ponee.io@flink.apache.org  Wed Mar 11 09:52:31 2020
Return-Path: <user-return-33398-archive-asf-public=cust-asf.ponee.io@flink.apache.org>
X-Original-To: archive-asf-public@cust-asf.ponee.io
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [207.244.88.153])
	by mx-eu-01.ponee.io (Postfix) with SMTP id 8D50118060E
	for <archive-asf-public@cust-asf.ponee.io>; Wed, 11 Mar 2020 10:52:31 +0100 (CET)
Received: (qmail 1983 invoked by uid 500); 11 Mar 2020 09:52:29 -0000
Mailing-List: contact user-help@flink.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@flink.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@flink.apache.org>
List-Post: <mailto:user@flink.apache.org>
List-Id: <user.flink.apache.org>
Delivered-To: mailing list user@flink.apache.org
Received: (qmail 1964 invoked by uid 99); 11 Mar 2020 09:52:29 -0000
Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Mar 2020 09:52:29 +0000
Received: from localhost (localhost [127.0.0.1])
	by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 5E855C158A;
	Wed, 11 Mar 2020 09:52:29 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: 0.223
X-Spam-Level:
X-Spam-Status: No, score=0.223 tagged_above=-999 required=6.31
	tests=[HTML_FONT_FACE_BAD=0.001, HTML_MESSAGE=0.2,
	KAM_DMARC_STATUS=0.01, RCVD_IN_DNSWL_NONE=-0.0001,
	SPF_HELO_NONE=0.001, SPF_PASS=-0.001, T_KAM_HTML_FONT_INVALID=0.01,
	UNPARSEABLE_RELAY=0.001, URIBL_BLOCKED=0.001] autolearn=disabled
Received: from mx1-he-de.apache.org ([10.40.0.8])
	by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024)
	with ESMTP id GKqPwGG4BdCu; Wed, 11 Mar 2020 09:52:24 +0000 (UTC)
Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=115.124.28.3; helo=out28-3.mail.aliyun.com; envelope-from=wanglei2@geekplus.com.cn; receiver=<UNKNOWN> 
Received: from out28-3.mail.aliyun.com (out28-3.mail.aliyun.com [115.124.28.3])
	by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id 36C0B7DD38;
	Wed, 11 Mar 2020 09:52:22 +0000 (UTC)
X-Alimail-AntiSpam:AC=CONTINUE;BC=0.07287355|-1;CH=green;DM=||false|;DS=CONTINUE|ham_news_journal|0.00515129-0.000213119-0.994636;FP=0|0|0|0|0|-1|-1|-1;HT=e02c03293;MF=wanglei2@geekplus.com.cn;NM=1;PH=DS;RN=2;RT=2;SR=0;TI=SMTPD_---.Gzg9dmB_1583920333;
Received: from DESKTOP-9VMLJ41(mailfrom:wanglei2@geekplus.com.cn fp:SMTPD_---.Gzg9dmB_1583920333)
          by smtp.aliyun-inc.com(10.147.41.158);
          Wed, 11 Mar 2020 17:52:14 +0800
Date: Wed, 11 Mar 2020 17:52:14 +0800
From: "wanglei2@geekplus.com.cn" <wanglei2@geekplus.com.cn>
To: user <user@flink.apache.org>, 
	user-zh <user-zh@flink.apache.org>
Subject: =?GB2312?B?u9i4tDoganNvbiDW0CB0aW1lc3RhbXAgwODQzdTaanNvbtbQ1PXR+dC0ssXE3LG7IGZsaW5rIHNxbCDKtrHw?=
References: <20200311174147734971137@geekplus.com.cn>
X-Priority: 3
X-GUID: F09DD335-29DC-457C-843A-72A80ADDDF1B
X-Has-Attach: no
X-Mailer: Foxmail 7.2.12.322[en]
Mime-Version: 1.0
Message-ID: <20200311175213222081147@geekplus.com.cn>
Content-Type: multipart/alternative;
	boundary="----=_001_NextPart742086731118_=----"

This is a multi-part message in MIME format.

------=_001_NextPart742086731118_=----
Content-Type: text/plain;
	charset="GB2312"
Content-Transfer-Encoding: base64

DQpTb3JyeSBpIHNlbnQgdGhlIENoaW5lc2Ugd3JpdHRlbiBlbWFpbCB0byB1c2VyQCANCkxldCBt
ZSB0cmFuc2xhdGUgaXQgdG8gRW5nbGlzaC4NCg0KSSAgY3JlYXRlIGEgdGFibGUgdXNpbmcgc3Fs
LWNsaWVudCBmcm9tIGthZmthIHRvcGljOg0KQ1JFQVRFIFRBQkxFIG9yZGVyX3N0YXR1cyAoDQog
ICAgICBvdXRfb3JkZXJfY29kZSBWQVJDSEFSLA0KICAgICAgaW50cHV0X2RhdGUgVElNRVNUQU1Q
KDMpLA0KICAgICAgb3duZXJfY29kZSBWQVJDSEFSLA0KICAgICAgc3RhdHVzIElOVA0KICApIFdJ
VEggKA0KICAgICAgJ2Nvbm5lY3Rvci50eXBlJyA9ICdrYWZrYScsLi4uLi4uLi4uDQogICAgICAn
Zm9ybWF0LnR5cGUnID0gJ2pzb24nLCAgICAgICdmb3JtYXQuZGVyaXZlLXNjaGVtYScgPSAndHJ1
ZScgICApDQpUaGVuIEkgc2VuZCBtZXNzYWdlIHRvIHRoZSB0b3BpYzogeyJvdXRfb3JkZXJfY29k
ZSI6Ik1BTUlDSzIwMjAwMzEwNDgiLCJpbnB1dF9kYXRlIjoiMjAyMC0wMy0xMVQxMzowMDowMC4x
MjNaIiwib3duZXJfY29kZSI6IldEVExFTjA0Iiwic3RhdHVzIjo5MH0NCkJ1dCB0aGUgaW5wdXRf
ZGF0ZSBpcyBub3QgcmVjb2duaXplZCBvbiB0aGUgc3FsLWNsaWVudCBhbmQgaXMgbnVsbKOsIGV2
ZW4gaSAgdHJpZWQgICAxNTgzODI4NzAwMjQwICAiMjAyMC0wMy0xMSAxMzowMDowMCIgICIyMDIw
LTAzLTExIDEzOjAwOjAwLjAwMCIgDQoNCkhvdyBzaG91bGQgdGhlIHRpbWVzdGFtcCgzKSBsb29r
IGxpa2UgaW4gdGhlIGpzb24gbWVzc2FnZT8NCg0KVGhhbmtzo6wNCkxlaQ0KIA0KDQoNCg0KDQp3
YW5nbGVpMkBnZWVrcGx1cy5jb20uY24NCiANCreivP7Iy6O6IHdhbmdsZWkyQGdlZWtwbHVzLmNv
bS5jbg0Kt6LLzcqxvOSjuiAyMDIwLTAzLTExIDE3OjQxDQrK1bz+yMujuiB1c2VyDQrW98zio7og
anNvbiDW0CB0aW1lc3RhbXAgwODQzdTaanNvbtbQ1PXR+dC0ssXE3LG7IGZsaW5rIHNxbCDKtrHw
DQoNCtPDIHNxbC1jbGllbnQgY3JlYXRlIMHL0ru49iBrYWZrYSB0YWJsZaO6DQpDUkVBVEUgVEFC
TEUgb3JkZXJfc3RhdHVzICgNCiAgICAgIG91dF9vcmRlcl9jb2RlIFZBUkNIQVIsDQogICAgICBp
bnRwdXRfZGF0ZSBUSU1FU1RBTVAoMyksDQogICAgICBvd25lcl9jb2RlIFZBUkNIQVIsDQogICAg
ICBzdGF0dXMgSU5UDQogICkgV0lUSCAoDQogICAgICAnY29ubmVjdG9yLnR5cGUnID0gJ2thZmth
JywuLi4uLi4uLi4NCiAgICAgICdmb3JtYXQudHlwZScgPSAnanNvbicsICAgICAgJ2Zvcm1hdC5k
ZXJpdmUtc2NoZW1hJyA9ICd0cnVlJyAgICkNCsi7uvPN+SBrYWZrYSDV4rj2IHRvcGljILeiy83P
+8+io7p7Im91dF9vcmRlcl9jb2RlIjoiTUFNSUNLMjAyMDAzMTA0OCIsImlucHV0X2RhdGUiOiIy
MDIwLTAzLTExVDEzOjAwOjAwLjEyM1oiLCJvd25lcl9jb2RlIjoiV0RUTEVOMDQiLCJzdGF0dXMi
OjkwfQ0KaW5wdXRfZGF0ZSDU2iBzcWwtY2xpbmV0ILbLyrzW1crHIE5VTEwuIA0KztKw0SC3osvN
tcQgaW5wdXRfZGF0ZSC4xLPJIDE1ODM4Mjg3MDAyNDAgICIyMDIwLTAzLTExIDEzOjAwOjAwIiAg
IjIwMjAtMDMtMTEgMTM6MDA6MDAuMDAwIiDSsra8srvQ0KGjIA0K1eK49iBUSU1FU1RBTVCjqDOj
qdTaSlNPTiDW0NOmuMPQtLPJyrLDtNH519PE2KO/DQoNCtC70LujrA0KzfXA2g0KDQoNCg0Kd2Fu
Z2xlaTJAZ2Vla3BsdXMuY29tLmNuDQo=

------=_001_NextPart742086731118_=----
Content-Type: text/html;
	charset="GB2312"
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charse=
t=3DGB2312"><style>body { line-height: 1.5; }blockquote { margin-top: 0px;=
 margin-bottom: 0px; margin-left: 0.5em; }p { margin-top: 0px; margin-bott=
om: 0px; }div.FoxDiv20200311174409783694 { }body { font-size: 10.5pt; font=
-family: 'Microsoft YaHei UI'; color: rgb(0, 0, 0); line-height: 1.5; }</s=
tyle></head><body>=0A<div><span></span><br></div>=0A<div>Sorry i sent the =
Chinese written email to user@&nbsp;</div><div>Let me translate it to Engl=
ish.</div><div><br></div><div>I &nbsp;create a table using sql-client from=
 kafka topic:</div><div><pre style=3D"font-family: Consolas; font-size: 9.=
8pt;"><span style=3D"color: rgb(0, 0, 128); font-weight: bold;">CREATE TAB=
LE </span>order_status (<br>      out_order_code <span style=3D"color: rgb=
(0, 0, 128); font-weight: bold;">VARCHAR</span>,<br>      intput_date <spa=
n style=3D"color: rgb(0, 0, 128); font-weight: bold;">TIMESTAMP</span>(<sp=
an style=3D"color: rgb(0, 0, 255);">3</span>),<br>      owner_code <span s=
tyle=3D"color: rgb(0, 0, 128); font-weight: bold;">VARCHAR</span>,<br>    =
  status <span style=3D"color: rgb(0, 0, 128); font-weight: bold;">INT<br>=
</span><span style=3D"color: rgb(128, 128, 128); font-style: italic;">  </=
span>) <span style=3D"color: rgb(0, 0, 128); font-weight: bold;">WITH </sp=
an>(<br>      <span style=3D"color: rgb(0, 128, 0); font-weight: bold;">'c=
onnector.type' </span>=3D <span style=3D"color: rgb(0, 128, 0); font-weigh=
t: bold;">'kafka'</span>,</pre><pre style=3D"font-family: Consolas; font-s=
ize: 9.8pt;">.........<br>      <span style=3D"font-size: 9.8pt; line-heig=
ht: 1.5; color: rgb(0, 128, 0); font-weight: bold; background-color: trans=
parent;">'format.type' </span><span style=3D"font-size: 9.8pt; line-height=
: 1.5; background-color: transparent;">=3D </span><span style=3D"font-size=
: 9.8pt; line-height: 1.5; color: rgb(0, 128, 0); font-weight: bold; backg=
round-color: transparent;">'json'</span><span style=3D"font-size: 9.8pt; l=
ine-height: 1.5; background-color: transparent;">,</span><pre style=3D"fon=
t-family: Consolas; font-size: 9.8pt;"><span style=3D"color: rgb(0, 128, 0=
); font-weight: bold;">      'format.derive-schema' </span>=3D <span style=
=3D"color: rgb(0, 128, 0); font-weight: bold;">'true'</span></pre><span st=
yle=3D"color: rgb(0, 128, 0); font-weight: bold;">   </span>)</pre></div><=
div>Then I send message to the topic:&nbsp;<span style=3D"font-size: 10.5p=
t; line-height: 1.5; background-color: transparent;">{"out_order_code":"MA=
MICK2020031048","input_date":"2020-03-11T13:00:00.123Z","owner_code":"WDTL=
EN04","status":90}</span></div><div><span style=3D"font-size: 10.5pt; line=
-height: 1.5; background-color: transparent;">But the input_date is not re=
cognized on the sql-client and is null=A3=AC even i &nbsp;tried &nbsp;&nbs=
p;</span><span style=3D"font-size: 10.5pt; line-height: 1.5; background-co=
lor: transparent;">1583828700240 &nbsp;"2020-03-11 13:00:00" &nbsp;"2020-0=
3-11 13:00:00.000"&nbsp;</span></div><div><span style=3D"font-size: 10.5pt=
; line-height: 1.5; background-color: transparent;"><br></span></div><div>=
How should the timestamp(3) look like in the json message?</div><div><br><=
/div><div>Thanks=A3=AC</div><div>Lei</div><div>&nbsp;</div><div><br></div>=
<hr style=3D"width: 210px; height: 1px;" color=3D"#b5c4df" size=3D"1" alig=
n=3D"left">=0A<div><span><div style=3D"margin: 10px;"><div style=3D"text-i=
ndent: 0em; clear: both; margin: 10px; padding: 0px; border: 0px; border-i=
mage-source: initial; border-image-slice: initial; border-image-width: ini=
tial; border-image-outset: initial; border-image-repeat: initial; outline:=
 0px; font-variant-ligatures: normal; line-height: 21px;"><br></div><div s=
tyle=3D"font-size: 14px; clear: both; margin: 10px; padding: 0px; border: =
0px; border-image-source: initial; border-image-slice: initial; border-ima=
ge-width: initial; border-image-outset: initial; border-image-repeat: init=
ial; outline: 0px; font-variant-ligatures: normal;"><div style=3D"font-siz=
e: 13px; margin: 0px; padding: 0px; border: 0px; border-image-source: init=
ial; border-image-slice: initial; border-image-width: initial; border-imag=
e-outset: initial; border-image-repeat: initial; outline: 0px; clear: both=
;"><p class=3D"MsoNormal" style=3D"font-family: Tahoma, Arial; line-height=
: normal; margin-right: 0px; margin-left: 0px; font-variant-ligatures: nor=
mal; text-align: justify; font-stretch: normal;"><span style=3D"font-famil=
y: '=CE=A2=C8=ED=D1=C5=BA=DA Light', sans-serif; font-size: 15px; line-hei=
ght: 21px; text-align: start;">wanglei2@geekplus.com.cn</span></p></div></=
div></div></span></div>=0A<blockquote style=3D"margin-Top: 0px; margin-Bot=
tom: 0px; margin-Left: 0.5em"><div>&nbsp;</div><div style=3D"border:none;b=
order-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><div style=3D"PAD=
DING-RIGHT: 8px; PADDING-LEFT: 8px; FONT-SIZE: 12px;FONT-FAMILY:tahoma;COL=
OR:#000000; BACKGROUND: #efefef; PADDING-BOTTOM: 8px; PADDING-TOP: 8px"><d=
iv><b>=B7=A2=BC=FE=C8=CB=A3=BA</b>&nbsp;<a href=3D"mailto:wanglei2@geekplu=
s.com.cn">wanglei2@geekplus.com.cn</a></div><div><b>=B7=A2=CB=CD=CA=B1=BC=
=E4=A3=BA</b>&nbsp;2020-03-11&nbsp;17:41</div><div><b>=CA=D5=BC=FE=C8=CB=
=A3=BA</b>&nbsp;<a href=3D"mailto:user@flink.apache.org">user</a></div><di=
v><b>=D6=F7=CC=E2=A3=BA</b>&nbsp;json =D6=D0 timestamp =C0=E0=D0=CD=D4=DAj=
son=D6=D0=D4=F5=D1=F9=D0=B4=B2=C5=C4=DC=B1=BB flink sql =CA=B6=B1=F0</div>=
</div></div><div><div class=3D"FoxDiv20200311174409783694">=0A<div><span><=
/span><br></div>=0A<div>=D3=C3 sql-client create =C1=CB=D2=BB=B8=F6 kafka =
table=A3=BA</div><div><pre style=3D"font-family: Consolas; font-size: 9.8p=
t;"><span style=3D"color:#000080;font-weight:bold;">CREATE TABLE </span>or=
der_status (<br>      out_order_code <span style=3D"color:#000080;font-wei=
ght:bold;">VARCHAR</span>,<br>      intput_date <span style=3D"color:#0000=
80;font-weight:bold;">TIMESTAMP</span>(<span style=3D"color:#0000ff;">3</s=
pan>),<br>      owner_code <span style=3D"color:#000080;font-weight:bold;"=
>VARCHAR</span>,<br>      status <span style=3D"color:#000080;font-weight:=
bold;">INT<br></span><span style=3D"color:#808080;font-style:italic;">  </=
span>) <span style=3D"color:#000080;font-weight:bold;">WITH </span>(<br>  =
    <span style=3D"color:#008000;font-weight:bold;">'connector.type' </spa=
n>=3D <span style=3D"color:#008000;font-weight:bold;">'kafka'</span>,</pre=
><pre style=3D"font-family: Consolas; font-size: 9.8pt;">.........<br>    =
  <span style=3D"font-size: 9.8pt; line-height: 1.5; color: rgb(0, 128, 0)=
; font-weight: bold; background-color: transparent;">'format.type' </span>=
<span style=3D"font-size: 9.8pt; line-height: 1.5; background-color: trans=
parent;">=3D </span><span style=3D"font-size: 9.8pt; line-height: 1.5; col=
or: rgb(0, 128, 0); font-weight: bold; background-color: transparent;">'js=
on'</span><span style=3D"font-size: 9.8pt; line-height: 1.5; background-co=
lor: transparent;">,</span><pre style=3D"font-family: Consolas; font-size:=
 9.8pt;"><span style=3D"color:#008000;font-weight:bold;">      'format.der=
ive-schema' </span>=3D <span style=3D"color:#008000;font-weight:bold;">'tr=
ue'</span></pre><span style=3D"color:#008000;font-weight:bold;">   </span>=
)</pre></div><div>=C8=BB=BA=F3=CD=F9 kafka =D5=E2=B8=F6 topic =B7=A2=CB=CD=
=CF=FB=CF=A2=A3=BA{"out_order_code":"MAMICK2020031048","input_date":"2020-=
03-11T13:00:00.123Z","owner_code":"WDTLEN04","status":90}</div><div>input_=
date =D4=DA sql-clinet =B6=CB=CA=BC=D6=D5=CA=C7 NULL.&nbsp;</div><div>=CE=
=D2=B0=D1 =B7=A2=CB=CD=B5=C4 input_date =B8=C4=B3=C9 1583828700240 &nbsp;"=
2020-03-11 13:00:00" &nbsp;"2020-03-11 13:00:00.000" =D2=B2=B6=BC=B2=BB=D0=
=D0=A1=A3&nbsp;</div><div>=D5=E2=B8=F6 TIMESTAMP=A3=A83=A3=A9=D4=DAJSON =
=D6=D0=D3=A6=B8=C3=D0=B4=B3=C9=CA=B2=C3=B4=D1=F9=D7=D3=C4=D8=A3=BF</div><d=
iv><br></div><div>=D0=BB=D0=BB=A3=AC</div><div>=CD=F5=C0=DA</div><div><br>=
</div><hr style=3D"width: 210px; height: 1px;" color=3D"#b5c4df" size=3D"1=
" align=3D"left">=0A<div><span style=3D"font-size: 15px;"><div style=3D"ma=
rgin: 10px;"><div style=3D"text-indent: 0em; clear: both; margin: 10px; pa=
dding: 0px; border: 0px; border-image-source: initial; border-image-slice:=
 initial; border-image-width: initial; border-image-outset: initial; borde=
r-image-repeat: initial; outline: 0px; font-variant-ligatures: normal; lin=
e-height: 21px;"><font face=3D"=CE=A2=C8=ED=D1=C5=BA=DA Light, sans-serif"=
>wanglei2@geekplus.com.cn</font></div></div></span></div>=0A</div></div></=
blockquote>=0A</body></html>
------=_001_NextPart742086731118_=------