在USQL代码中修复小数点后的Precision值 [英] Fix Precision value after decimal in USQL code
问题描述
大家好,
我正在编写一个U-SQL代码,其中一列为小数,我希望此列在小数点后给出4个精度
下面例子
12.3 >> 12.3000
12.3 >> 12.3000
12.43>> 12.4300
12.43 >> 12.4300
2 >> 2.0000
2 >> 2.0000
我已经使用了+ 0.0000m添加列,但我没有获得所有记录的一致值.
I have used +0.0000m to add the column, but I am not getting a consistent value for all records.
有人可以帮助我解决任何问题吗
Can someone help me with any function which can resolved my issue
感谢& amp;问候,Vipin jha MCP
Thankx & regards, Vipin jha MCP
推荐答案
Vipin
您是否尝试过在U-SQL中使用提取器?
Have you tried using extractors in U-SQL ?
以下是有关Extractor的一些文档:
Here are a couple of documents on Extractors :
https://github.com/Azure/AzureDataLake/blob/master/docs/Release_Notes/2018/2018_Spring/USQL_Release_Notes_2018_Spring.md
https://github.com/Azure/AzureDataLake/blob/master/docs/Release_Notes/2018/2018_Spring/USQL_Release_Notes_2018_Spring.md
https://docs.microsoft.com/zh-cn/u-sql/functions/operators/built-in-extractors
https://docs.microsoft.com/en-us/u-sql/functions/operators/built-in-extractors
看看这些,让我们知道是否有帮助.否则,我们可以继续进行进一步的研究.
Have a look at these and let us know if it helps. Else, we can continue to probe in further.
这篇关于在USQL代码中修复小数点后的Precision值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!