使用ODBC驱动程序的BI分析工具无法转换为其类型 [英] BI analytics tools with the ODBC driver failed to convert to its type

问题描述

嗨团队，

我们在使用ODBC驱动程序转换数据时遇到数据类型不匹配的问题。在宇宙中，DB少数字段被保持为"双"字段。如果我使用ODBC驱动程序进行转换，
我不确定为什么它在SQL中显示为两个不同的数据类型，因为很少有double类型的列被转换为bigint，因为其他列转换为float。这是我们遗失的东西吗？我们遵循的来源是  https://docs.microsoft.com/ en-us / azure / cosmos-db / odbc-driver   FYR。 

We are facing mismatch in datatypes while converting the data using ODBC driver. In cosmos, DB few fields are maintained as "double" and If I convert using ODBC driver, I'm not sure why it's displaying as two different datatypes in SQL for few columns of type double is converted into bigint for other columns converted into a float. Is it something we are missing? The source we followed is https://docs.microsoft.com/en-us/azure/cosmos-db/odbc-driver FYR. 

推荐答案

您好，

感谢您的反馈。你能否分享一下你正在使用的样本文档。

Thanks for your feedback. Could you please share the sample document you are using.

根据我的理解，你正在尝试从DocumentDB转换为SQL，所以在DocumentDB中没有多种数据类型的概念。所有值都将存储为字符串。所以要转换成不同的数据类型。 ODBC驱动程序将获取
样本数据，并尝试根据特定列的样本中存在的数据猜测数据类型。这就是为什么一些带有double的列被转换为bigint而另一些被转换为浮动的原因。

As per my understanding, you are trying to convert from DocumentDB to SQL, So in DocumentDB there is no concept of multiple data types. All the values would be stored as strings. So for converting into different data type. The ODBC driver will pick up the sample data and try to guess the data type as per the data present in that sample for particular columns. That is the reason why some of the columns with double are converted to bigint and some to float.

希望它有所帮助。

这篇关于使用ODBC驱动程序的BI分析工具无法转换为其类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！