Github user paul-rogers commented on the issue: https://github.com/apache/drill/pull/517 Hi Dave, I agree that Drill Decimal support clearly needs attention. I'm expermenting with adjusting the template code to at least generate a meaningful conversion for all int x decimal types when the values fit. Looks like current behavior will be that if we convert an int that is too large for a scale of 0, we won't adjust the scale. That is, if we always leave scale=0, then we'll do the following obviously wrong converstion: big int: 123,456,789,012 Dec 9: 456,789,012 We want a scale of 3, so that the answer is: Dec 9: 123,456,789,000 And, of course, we should round the least significant digit, which it seems we don't do. So, our fix will work only for the simple case, not for the more complex case. We could leverage your fix to properly set the scale as well as the precision.
--- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---