We have been using data from Hadoop via Hive ODBC in SAS and noticed something strange. A large integer field is returning different results in SAS than when the same query is run in HUE. I’ve done some testing and it looks to me like a SAS format issue, but I can’t figure out how to resolve. Have you seen this before? Here is an example: Pull riskid from Hue (9176485618548934709) and put in a SAS where statement (see below) and you return 9176485618548934656 instead of 9176485618548934709
... View more