• Solution to the problem of error reporting when bigint to int with sign in SQL Server


    One requirement is to store multiple states (including all kinds of exception and warning states that can exist at the same time) in a cloud monitoring state value. Bit operation mechanism is used to store multiple states in an int. At present, the amount of monitoring log data is very large (100 million level), and […]

  • Convert string data to bigint in hive


    Use cast function to convert string to bigint: SELECT CAST(‘00321’ AS BIGINT) FROM table; As a BIGINT it will show on the screen and in delimited text files as 321. reference resources:Hive – Converting a string to bigint Supplementary knowledge:Solve the problem of association data error by associating bigint and varchar fields in hive Implicitly […]