qnsh
V2EX  ›  问与答

有懂 elasticsearch 的吗,这样的数据结构如何索引查询

  •  
  •   qnsh · Oct 20, 2021 · 2260 views
    This topic created in 1841 days ago, the information mentioned may be changed or developed.
    {
        "sheets": {
            "Sheet1": {
                "name": "Sheet1",
                "data": {
                    "dataTable": {
                        "0": {
                            "0": {
                                "value": 0
                            }
                        },
                        "1": {
                            "1": {
                                "value": 0,                           
                                "formula": "A1+B1"
                            }
                        }
                    }
                },
                "index": 0
            },
            "Sheet2": {
                "name": "Sheet2",
                "data": {
                    "dataTable": {
                        "0": {
                            "0": {
                                "value": 0,
                                "formula": "C1+D1"
                            }
                        }
                    }
                },
                "index": 1
            }
        }
    }
    

    数据格式如上,要查询 formula 包含"A1"的应该怎么操作。

    3 replies  •  2021-10-22 15:52:27 +08:00
    urlk
    urlk
    Oct 20, 2021❤️1
    1
    结构有问题吧 ? 存的时候字段要统一呀
    SjwNo1
    SjwNo1
    Oct 20, 2021❤️1
    2
    nested query,但是你这个 dataTable Item 不固定有点蛋疼啊,建议改数据结构
    leafre
    leafre
    Oct 22, 2021 via Android
    3
    nested + bool
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1388 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 30ms · UTC 20:18 · PVG 04:18 · LAX 12:18 · JFK 15:18
    ♥ Do have faith in what you're doing.