vverr
V2EX  ›  问与答

急,大佬们, Hive 里面 cast 转换大数用啥类型?

  •  
  •   vverr · Dec 15, 2020 · 1322 views
    This topic created in 2120 days ago, the information mentioned may be changed or developed.

    select cast('340282366920938463463374607431768211455' as bigint);


    试了几个都不行

    2 replies  •  2020-12-15 23:36:14 +08:00
    Meltdown
        1
    Meltdown  
       Dec 15, 2020 via Android
    怎么不行
    vverr
        2
    vverr  
    OP
       Dec 15, 2020
    @Meltdown #1 数太大 返回都是 NULL
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2321 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 83ms · UTC 10:03 · PVG 18:03 · LAX 03:03 · JFK 06:03
    ♥ Do have faith in what you're doing.