azure - 在u-sql中转换数据类型和concat列
问题描述
如何在 U-SQL 中转换数据类型和连接列?
@output =
SELECT DISTINCT (kco.ToString + "-" + hta_ref.ToString + "-" + his_ref.ToString) AS hs_isstaskID,
(kco.ToString + "-" + his_ref.ToString) AS HS_IssueID,
(kco.ToString + "-" + hta_ref.ToString) AS hs_task_ID,
*
FROM @input;
解决方案
ToString
是一种方法,因此通常需要括号,例如
@output =
SELECT DISTINCT (kco.ToString() + "-" + hta_ref.ToString() + "-" + his_ref.ToString()) AS hs_isstaskID,
(kco.ToString() + "-" + his_ref.ToString()) AS HS_IssueID,
(kco.ToString() + "-" + hta_ref.ToString()) AS hs_task_ID,
*
FROM @input;
如果数据转换导致问题,那么您可能需要TryParse
按照此处实施。
推荐阅读
- javascript - 在联合js中绘制样式圈
- amazon-web-services - 可以使用 API 代替 SDK 吗?
- asp.net-core - Build error of ASP.NET Core - "...current settings, version 2.1.0-preview3-26411-06 would be used instead"
- r - R - R6 class as a rigid "read-only" data structure
- javascript - 错误:无法读取未定义的属性“顶部”
- vb.net - VB.NET System.StackOverflowException After Adding Redis
- python - 我可以从 HDF5 数据集中删除元素吗?
- java - remember username and password checkbox
- c++ - Visual Studio 15.7 Update: change in constructor inheritance
- javascript - Pubnub sending messages multiple times