MongoDB Data Types | Transformation Data Types | Range and Description |
|---|---|---|
Array | NA | Simba MongoDB JDBC driver re-normalizes the data in the array into virtual tables. |
Boolean | String | Precision of 1 |
Date | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to second) |
NumberDouble | Double | Precision 15 |
NumberInt | Integer | Precision 10, scale 0 |
NumberLong | Decimal | Precision 1 to 28 digits, scale 0 to 28 |
Object | NA | Simba MongoDB JDBC driver re-normalizes the data in the object into virtual tables. |
ObjectID | String | 1 to 104,857,600 characters |
String | String | 1 to 104,857,600 characters |