问题一:DataWorks怎么在参数里面配置获取运行的时间?
DataWorks怎么在参数里面配置获取运行的时间?
参考回答:
定时时间 还是实际执行的时间呢 后者需要使用 比如sql里使用MaxCompute的时间函数之类的
关于本问题的更多回答可点击原文查看:
https://developer.aliyun.com/ask/647878
问题二:在DataWorks数据分析里面增加数据目录,是不是在这里的数据目录看不到表清单?
在DataWorks数据分析里面增加数据目录,如果Hologres的表是外表形式,是不是在这里的数据目录看不到表清单?
参考回答:
在数据地图能搜索到对应的表么 在数据地图按对应数据源进行过滤搜索该表
关于本问题的更多回答可点击原文查看:
https://developer.aliyun.com/ask/647876
问题三:dataworks有没有主动推送定制化的消息?
dataworks有没有主动推送定制化的消息,比方说我写条sql,我希望吧这条sql跑出来的内容每天定时通过机器人推送到钉钉群?
参考回答:
可以试一下数据服务的数据推送能力
https://help.aliyun.com/zh/dataworks/user-guide/push-data?spm=a2c4g.11186623.0.i6
关于本问题的更多回答可点击原文查看:
https://developer.aliyun.com/ask/647873
问题四:DataWorks 一直在等待 gateway 资源怎么办?
DataWorks 一直在等待 gateway 资源怎么办?
oad driver class: com.mysql.cj.jdbc.Driver
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:172)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:444)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)
at java.sql.DriverManager.getConnection(DriverManager.java:674)
at java.sql.DriverManager.getConnection(DriverManager.java:256)
at com.alibaba.dw.alisa.wrapper.util.ConnectionManager.getJDBCConnection(ConnectionManager.java:30)
at com.alibaba.dw.alisa.wrapper.JdbcWrapper.executeJdbcSql(JdbcWrapper.java:99)
at com.alibaba.dw.alisa.wrapper.JdbcWrapper.submitJob(JdbcWrapper.java:43)
at com.alibaba.dataworks.dwalisa.DwalisaWrapperMain.main(DwalisaWrapperMain.java:265)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:103)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:165)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:92)
at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:982)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:852)
... 9 more
Caused by: java.net.SocketTimeoutException: connect timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:639)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:173)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:66)
... 12 more
sql execute failed! Communications link failure
参考回答:
点「带参运行」选择的是独享调度资源组还是公共调度资源组 可以看下对应资源组水位是不是满了,点「带参运行」选择测通的独享调度资源组
关于本问题的更多回答可点击原文查看:
https://developer.aliyun.com/ask/647869
问题五:DataWorks支持同一地域下的工作空间使用不同的时区吗?
DataWorks支持同一地域下的工作空间使用不同的时区吗?
参考回答:
不支持
关于本问题的更多回答可点击原文查看: