Skip to content

Instantly share code, notes, and snippets.

@zabetak

zabetak/str_dec_hive_mssql_mysql.csv

Created December 2, 2021 13:10
Show Gist options
  • Save zabetak/38d5c9ce3b66acc4cf3ee93f3b39bfec to your computer and use it in GitHub Desktop.
Save zabetak/38d5c9ce3b66acc4cf3ee93f3b39bfec to your computer and use it in GitHub Desktop.
Download ZIP
String decimal comparisons/arithmetic in Hive, MySQL, MSSQL
Raw
str_dec_hive_mssql_mysql.csv
QID Hive 1.2.0 Hive 3.1.0 MySQL MSSQL 2017
Q1 false true 1 false
Q2 false false 0 false
Q3 true true 1 ERROR
Q4 false true 1 true
Q5 false true 1 ERROR
Q6 true true 1 false
Q7 false false 0 false
Q8 false true ERROR ERROR
Q9 true true 1 false
Q11 2.4E19 2.4E19 2.4E19 24000000000000000000.5
Q12 1.2E19 1.2E19 1.2E19 12000000000000000000.6
Q13 12000000000000000000.58 12000000000000000000.58 12000000000000000000.58 12000000000000000000.58
Q14 1.2E19 12000000000000000000.58 12000000000000000000.58 12000000000000000000.58
Q15 1.2E19 1.2E19 1.2E19 OVERFLOW ERROR
Q16 1.2E19 1.2E19 1.2E19 OVERFLOW ERROR
Q17 1.2E19 1.2E19 1.2E19 120000000000000000000.08
Q18 2.4E19 2.4E19 2.4E19 24000000000000000000.5
Q19 2.4E19 2.4E19 2.4E19 24000000000000000000.5
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment