ClickHouse

1
#include "config.h"
2

3
#if USE_S2_GEOMETRY
4

5
#include <Columns/ColumnsNumber.h>
6
#include <Columns/ColumnTuple.h>
7
#include <DataTypes/DataTypesNumber.h>
8
#include <DataTypes/DataTypeTuple.h>
9
#include <Functions/FunctionFactory.h>
10
#include <Common/typeid_cast.h>
11
#include <base/range.h>
12

13
#include "s2_fwd.h"
14

15
class S2CellId;
16

17
namespace DB
18
{
19

20
namespace ErrorCodes
21
{
22
    extern const int ILLEGAL_TYPE_OF_ARGUMENT;
23
    extern const int BAD_ARGUMENTS;
24
    extern const int ILLEGAL_COLUMN;
25
}
26

27
namespace
28
{
29

30
/**
31
 *  Returns a point (longitude, latitude) in degrees
32
 */
33
class FunctionS2ToGeo : public IFunction
34
{
35
public:
36
    static constexpr auto name = "s2ToGeo";
37

38
    static FunctionPtr create(ContextPtr)
39
    {
40
        return std::make_shared<FunctionS2ToGeo>();
41
    }
42

43
    std::string getName() const override
44
    {
45
        return name;
46
    }
47

48
    size_t getNumberOfArguments() const override { return 1; }
49

50
    bool useDefaultImplementationForConstants() const override { return true; }
51

52
    bool isSuitableForShortCircuitArgumentsExecution(const DataTypesWithConstInfo & /*arguments*/) const override { return false; }
53

54
    DataTypePtr getReturnTypeImpl(const DataTypes & arguments) const override
55
    {
56
        const auto * arg = arguments[0].get();
57

58
        if (!WhichDataType(arg).isUInt64())
59
            throw Exception(
60
                ErrorCodes::ILLEGAL_TYPE_OF_ARGUMENT,
61
                "Illegal type {} of argument {} of function {}. Must be UInt64",
62
                arg->getName(), 1, getName());
63

64
        DataTypePtr element = std::make_shared<DataTypeFloat64>();
65

66
        return std::make_shared<DataTypeTuple>(DataTypes{element, element});
67
    }
68

69
    ColumnPtr executeImpl(const ColumnsWithTypeAndName & arguments, const DataTypePtr &, size_t input_rows_count) const override
70
    {
71
        auto non_const_arguments = arguments;
72
        for (auto & argument : non_const_arguments)
73
            argument.column = argument.column->convertToFullColumnIfConst();
74

75
        const auto * col_id = checkAndGetColumn<ColumnUInt64>(non_const_arguments[0].column.get());
76
        if (!col_id)
77
            throw Exception(
78
                ErrorCodes::ILLEGAL_COLUMN,
79
                "Illegal type {} of argument {} of function {}. Must be UInt64",
80
                arguments[0].type->getName(),
81
                1,
82
                getName());
83

84
        const auto & data_id = col_id->getData();
85

86
        auto col_longitude = ColumnFloat64::create();
87
        auto col_latitude = ColumnFloat64::create();
88

89
        auto & longitude = col_longitude->getData();
90
        longitude.reserve(input_rows_count);
91

92
        auto & latitude = col_latitude->getData();
93
        latitude.reserve(input_rows_count);
94

95
        for (size_t row = 0; row < input_rows_count; ++row)
96
        {
97
            const auto id = S2CellId(data_id[row]);
98

99
            if (!id.is_valid())
100
                throw Exception(ErrorCodes::BAD_ARGUMENTS, "CellId is invalid.");
101

102
            S2Point point = id.ToPoint();
103
            S2LatLng ll(point);
104

105
            longitude.emplace_back(ll.lng().degrees());
106
            latitude.emplace_back(ll.lat().degrees());
107
        }
108

109
        return ColumnTuple::create(Columns{std::move(col_longitude), std::move(col_latitude)});
110
    }
111

112
};
113

114
}
115

116
REGISTER_FUNCTION(S2ToGeo)
117
{
118
    factory.registerFunction<FunctionS2ToGeo>();
119
}
120

121

122
}
123

124
#endif
125