OmniSciDB  95562058bd
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Pages
CalciteDeserializerUtils.h File Reference
#include "DateAdd.h"
#include "DateTruncate.h"
#include "../Shared/sqldefs.h"
#include "../Shared/sqltypes.h"
#include "Logger/Logger.h"
+ Include dependency graph for CalciteDeserializerUtils.h:
+ This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Namespaces

 Analyzer
 

Functions

SQLOps to_sql_op (const std::string &op_str)
 
SQLAgg to_agg_kind (const std::string &agg_name)
 
SQLTypes to_sql_type (const std::string &type_name)
 
SQLTypeInfo get_agg_type (const SQLAgg agg_kind, const Analyzer::Expr *arg_expr)
 
ExtractField to_datepart_field (const std::string &)
 
DateaddField to_dateadd_field (const std::string &)
 
DatetruncField to_datediff_field (const std::string &)
 
std::shared_ptr
< Analyzer::Constant
make_fp_constant (const int64_t val, const SQLTypeInfo &ti)
 

Function Documentation

SQLTypeInfo get_agg_type ( const SQLAgg  agg_kind,
const Analyzer::Expr arg_expr 
)

Definition at line 26 of file CalciteDeserializerUtils.cpp.

References CHECK, g_bigint_count, Analyzer::Expr::get_type_info(), SQLTypeInfo::get_type_name(), SQLTypeInfo::is_integer(), SQLTypeInfo::is_varlen(), kAPPROX_COUNT_DISTINCT, kAVG, kBIGINT, kCOUNT, kDOUBLE, kINT, kMAX, kMIN, kSAMPLE, kSINGLE_VALUE, and kSUM.

Referenced by anonymous_namespace{RelAlgExecutor.cpp}::decide_approx_count_distinct_implementation(), and RelAlgTranslator::translateAggregateRex().

26  {
27  switch (agg_kind) {
28  case kCOUNT:
29  return SQLTypeInfo(g_bigint_count ? kBIGINT : kINT, false);
30  case kMIN:
31  case kMAX:
32  return arg_expr->get_type_info();
33  case kSUM:
34  return arg_expr->get_type_info().is_integer() ? SQLTypeInfo(kBIGINT, false)
35  : arg_expr->get_type_info();
36  case kAVG:
37  return SQLTypeInfo(kDOUBLE, false);
39  return SQLTypeInfo(kBIGINT, false);
40  case kSINGLE_VALUE:
41  if (arg_expr->get_type_info().is_varlen()) {
42  throw std::runtime_error("SINGLE_VALUE not supported on '" +
43  arg_expr->get_type_info().get_type_name() + "' input.");
44  }
45  case kSAMPLE:
46  return arg_expr->get_type_info();
47  default:
48  CHECK(false);
49  }
50  CHECK(false);
51  return SQLTypeInfo();
52 }
bool is_varlen() const
Definition: sqltypes.h:432
Definition: sqldefs.h:73
bool is_integer() const
Definition: sqltypes.h:419
bool g_bigint_count
Definition: sqldefs.h:75
const SQLTypeInfo & get_type_info() const
Definition: Analyzer.h:78
Definition: sqldefs.h:76
std::string get_type_name() const
Definition: sqltypes.h:362
#define CHECK(condition)
Definition: Logger.h:197
Definition: sqltypes.h:47
Definition: sqldefs.h:74
Definition: sqldefs.h:72

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

std::shared_ptr<Analyzer::Constant> make_fp_constant ( const int64_t  val,
const SQLTypeInfo ti 
)

Definition at line 200 of file CalciteDeserializerUtils.cpp.

References CHECK, Datum::doubleval, Datum::floatval, SQLTypeInfo::get_type(), kDOUBLE, and kFLOAT.

Referenced by RelAlgTranslator::translateLiteral().

201  {
202  Datum d;
203  switch (ti.get_type()) {
204  case kFLOAT:
205  d.floatval = val;
206  break;
207  case kDOUBLE:
208  d.doubleval = val;
209  break;
210  default:
211  CHECK(false);
212  }
213  return makeExpr<Analyzer::Constant>(ti, false, d);
214 }
HOST DEVICE SQLTypes get_type() const
Definition: sqltypes.h:259
float floatval
Definition: sqltypes.h:139
#define CHECK(condition)
Definition: Logger.h:197
double doubleval
Definition: sqltypes.h:140

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

SQLAgg to_agg_kind ( const std::string &  agg_name)
inline

Definition at line 94 of file CalciteDeserializerUtils.h.

References kAPPROX_COUNT_DISTINCT, kAVG, kCOUNT, kMAX, kMIN, kSAMPLE, kSINGLE_VALUE, and kSUM.

Referenced by anonymous_namespace{RelAlgDagBuilder.cpp}::parse_aggregate_expr().

94  {
95  if (agg_name == std::string("COUNT")) {
96  return kCOUNT;
97  }
98  if (agg_name == std::string("MIN")) {
99  return kMIN;
100  }
101  if (agg_name == std::string("MAX")) {
102  return kMAX;
103  }
104  if (agg_name == std::string("SUM")) {
105  return kSUM;
106  }
107  if (agg_name == std::string("AVG")) {
108  return kAVG;
109  }
110  if (agg_name == std::string("APPROX_COUNT_DISTINCT")) {
111  return kAPPROX_COUNT_DISTINCT;
112  }
113  if (agg_name == std::string("SAMPLE") || agg_name == std::string("LAST_SAMPLE")) {
114  return kSAMPLE;
115  }
116  if (agg_name == std::string("SINGLE_VALUE")) {
117  return kSINGLE_VALUE;
118  }
119  throw std::runtime_error("Aggregate function " + agg_name + " not supported");
120 }
Definition: sqldefs.h:73
Definition: sqldefs.h:75
Definition: sqldefs.h:76
Definition: sqldefs.h:74
Definition: sqldefs.h:72

+ Here is the caller graph for this function:

DateaddField to_dateadd_field ( const std::string &  )

Definition at line 102 of file CalciteDeserializerUtils.cpp.

References daCENTURY, daDAY, daDECADE, daHOUR, daMICROSECOND, daMILLENNIUM, daMILLISECOND, daMINUTE, daMONTH, daNANOSECOND, daQUARTER, daSECOND, daWEEK, daWEEKDAY, and daYEAR.

Referenced by RelAlgTranslator::translateDateadd().

102  {
103  DateaddField fieldno;
104  if (boost::iequals(field, "year") || boost::iequals(field, "yy") ||
105  boost::iequals(field, "yyyy") || boost::iequals(field, "sql_tsi_year")) {
106  fieldno = daYEAR;
107  } else if (boost::iequals(field, "quarter") || boost::iequals(field, "qq") ||
108  boost::iequals(field, "q") || boost::iequals(field, "sql_tsi_quarter")) {
109  fieldno = daQUARTER;
110  } else if (boost::iequals(field, "month") || boost::iequals(field, "mm") ||
111  boost::iequals(field, "m") || boost::iequals(field, "sql_tsi_month")) {
112  fieldno = daMONTH;
113  } else if (boost::iequals(field, "day") || boost::iequals(field, "dd") ||
114  boost::iequals(field, "d") || boost::iequals(field, "sql_tsi_day")) {
115  fieldno = daDAY;
116  } else if (boost::iequals(field, "week") || boost::iequals(field, "ww") ||
117  boost::iequals(field, "w") || boost::iequals(field, "sql_tsi_week")) {
118  fieldno = daWEEK;
119  } else if (boost::iequals(field, "hour") || boost::iequals(field, "hh") ||
120  boost::iequals(field, "sql_tsi_hour")) {
121  fieldno = daHOUR;
122  } else if (boost::iequals(field, "minute") || boost::iequals(field, "mi") ||
123  boost::iequals(field, "n") || boost::iequals(field, "sql_tsi_minute")) {
124  fieldno = daMINUTE;
125  } else if (boost::iequals(field, "second") || boost::iequals(field, "ss") ||
126  boost::iequals(field, "s") || boost::iequals(field, "sql_tsi_second")) {
127  fieldno = daSECOND;
128  } else if (boost::iequals(field, "millisecond") || boost::iequals(field, "ms")) {
129  fieldno = daMILLISECOND;
130  } else if (boost::iequals(field, "microsecond") || boost::iequals(field, "us") ||
131  boost::iequals(field, "sql_tsi_microsecond") ||
132  boost::iequals(field, "frac_second")) {
133  fieldno = daMICROSECOND;
134  } else if (boost::iequals(field, "nanosecond") || boost::iequals(field, "ns") ||
135  boost::iequals(field, "sql_tsi_frac_second")) {
136  fieldno = daNANOSECOND;
137  } else if (boost::iequals(field, "weekday") || boost::iequals(field, "dw")) {
138  fieldno = daWEEKDAY;
139  } else if (boost::iequals(field, "decade") || boost::iequals(field, "dc")) {
140  fieldno = daDECADE;
141  } else if (boost::iequals(field, "century")) {
142  fieldno = daCENTURY;
143  } else if (boost::iequals(field, "millennium")) {
144  fieldno = daMILLENNIUM;
145  } else {
146  throw std::runtime_error("Unsupported field in DATEADD function: " + field);
147  }
148  return fieldno;
149 }
Definition: DateAdd.h:47
const rapidjson::Value & field(const rapidjson::Value &obj, const char field[]) noexcept
Definition: JsonAccessors.h:31
Definition: DateAdd.h:43
DateaddField
Definition: DateAdd.h:42
Definition: DateAdd.h:56
Definition: DateAdd.h:46

+ Here is the caller graph for this function:

DatetruncField to_datediff_field ( const std::string &  )

Definition at line 151 of file CalciteDeserializerUtils.cpp.

References dtCENTURY, dtDAY, dtDECADE, dtHOUR, dtMICROSECOND, dtMILLENNIUM, dtMILLISECOND, dtMINUTE, dtMONTH, dtNANOSECOND, dtQUARTER, dtQUARTERDAY, dtSECOND, dtWEEK, and dtYEAR.

Referenced by RelAlgTranslator::translateDatediff().

151  {
152  DatetruncField fieldno;
153  if (boost::iequals(field, "year") || boost::iequals(field, "yy") ||
154  boost::iequals(field, "yyyy") || boost::iequals(field, "sql_tsi_year")) {
155  fieldno = dtYEAR;
156  } else if (boost::iequals(field, "quarter") || boost::iequals(field, "qq") ||
157  boost::iequals(field, "q") || boost::iequals(field, "sql_tsi_quarter")) {
158  fieldno = dtQUARTER;
159  } else if (boost::iequals(field, "month") || boost::iequals(field, "mm") ||
160  boost::iequals(field, "m") || boost::iequals(field, "sql_tsi_month")) {
161  fieldno = dtMONTH;
162  } else if (boost::iequals(field, "week") || boost::iequals(field, "ww") ||
163  boost::iequals(field, "w") || boost::iequals(field, "sql_tsi_week")) {
164  fieldno = dtWEEK;
165  } else if (boost::iequals(field, "day") || boost::iequals(field, "dd") ||
166  boost::iequals(field, "d") || boost::iequals(field, "sql_tsi_day")) {
167  fieldno = dtDAY;
168  } else if (boost::iequals(field, "quarterday")) {
169  fieldno = dtQUARTERDAY;
170  } else if (boost::iequals(field, "hour") || boost::iequals(field, "hh") ||
171  boost::iequals(field, "sql_tsi_hour")) {
172  fieldno = dtHOUR;
173  } else if (boost::iequals(field, "minute") || boost::iequals(field, "mi") ||
174  boost::iequals(field, "n") || boost::iequals(field, "sql_tsi_minute")) {
175  fieldno = dtMINUTE;
176  } else if (boost::iequals(field, "second") || boost::iequals(field, "ss") ||
177  boost::iequals(field, "s") || boost::iequals(field, "sql_tsi_second")) {
178  fieldno = dtSECOND;
179  } else if (boost::iequals(field, "millisecond") || boost::iequals(field, "ms")) {
180  fieldno = dtMILLISECOND;
181  } else if (boost::iequals(field, "microsecond") || boost::iequals(field, "us") ||
182  boost::iequals(field, "sql_tsi_microsecond") ||
183  boost::iequals(field, "frac_second")) {
184  fieldno = dtMICROSECOND;
185  } else if (boost::iequals(field, "nanosecond") || boost::iequals(field, "ns") ||
186  boost::iequals(field, "sql_tsi_frac_second")) {
187  fieldno = dtNANOSECOND;
188  } else if (boost::iequals(field, "decade") || boost::iequals(field, "dc")) {
189  fieldno = dtDECADE;
190  } else if (boost::iequals(field, "century")) {
191  fieldno = dtCENTURY;
192  } else if (boost::iequals(field, "millennium")) {
193  fieldno = dtMILLENNIUM;
194  } else {
195  throw std::runtime_error("Unsupported field in DATEDIFF function: " + field);
196  }
197  return fieldno;
198 }
const rapidjson::Value & field(const rapidjson::Value &obj, const char field[]) noexcept
Definition: JsonAccessors.h:31
DatetruncField
Definition: DateTruncate.h:27

+ Here is the caller graph for this function:

ExtractField to_datepart_field ( const std::string &  )

Definition at line 54 of file CalciteDeserializerUtils.cpp.

References kDAY, kDOY, kHOUR, kISODOW, kMICROSECOND, kMILLISECOND, kMINUTE, kMONTH, kNANOSECOND, kQUARTER, kQUARTERDAY, kSECOND, kWEEK, and kYEAR.

Referenced by RelAlgTranslator::translateDatepart().

54  {
55  ExtractField fieldno;
56  if (boost::iequals(field, "year") || boost::iequals(field, "yy") ||
57  boost::iequals(field, "yyyy") || boost::iequals(field, "sql_tsi_year")) {
58  fieldno = kYEAR;
59  } else if (boost::iequals(field, "quarter") || boost::iequals(field, "qq") ||
60  boost::iequals(field, "q") || boost::iequals(field, "sql_tsi_quarter")) {
61  fieldno = kQUARTER;
62  } else if (boost::iequals(field, "month") || boost::iequals(field, "mm") ||
63  boost::iequals(field, "m") || boost::iequals(field, "sql_tsi_month")) {
64  fieldno = kMONTH;
65  } else if (boost::iequals(field, "dayofyear") || boost::iequals(field, "dy") ||
66  boost::iequals(field, "y")) {
67  fieldno = kDOY;
68  } else if (boost::iequals(field, "day") || boost::iequals(field, "dd") ||
69  boost::iequals(field, "d") || boost::iequals(field, "sql_tsi_day")) {
70  fieldno = kDAY;
71  } else if (boost::iequals(field, "week") || boost::iequals(field, "ww") ||
72  boost::iequals(field, "w") || boost::iequals(field, "sql_tsi_week")) {
73  fieldno = kWEEK;
74  } else if (boost::iequals(field, "hour") || boost::iequals(field, "hh") ||
75  boost::iequals(field, "sql_tsi_hour")) {
76  fieldno = kHOUR;
77  } else if (boost::iequals(field, "minute") || boost::iequals(field, "mi") ||
78  boost::iequals(field, "n") || boost::iequals(field, "sql_tsi_minute")) {
79  fieldno = kMINUTE;
80  } else if (boost::iequals(field, "second") || boost::iequals(field, "ss") ||
81  boost::iequals(field, "s") || boost::iequals(field, "sql_tsi_second")) {
82  fieldno = kSECOND;
83  } else if (boost::iequals(field, "millisecond") || boost::iequals(field, "ms")) {
84  fieldno = kMILLISECOND;
85  } else if (boost::iequals(field, "microsecond") || boost::iequals(field, "us") ||
86  boost::iequals(field, "sql_tsi_microsecond") ||
87  boost::iequals(field, "frac_second")) {
88  fieldno = kMICROSECOND;
89  } else if (boost::iequals(field, "nanosecond") || boost::iequals(field, "ns") ||
90  boost::iequals(field, "sql_tsi_frac_second")) {
91  fieldno = kNANOSECOND;
92  } else if (boost::iequals(field, "weekday") || boost::iequals(field, "dw")) {
93  fieldno = kISODOW;
94  } else if (boost::iequals(field, "quarterday") || boost::iequals(field, "dq")) {
95  fieldno = kQUARTERDAY;
96  } else {
97  throw std::runtime_error("Unsupported field in DATEPART function: " + field);
98  }
99  return fieldno;
100 }
const rapidjson::Value & field(const rapidjson::Value &obj, const char field[]) noexcept
Definition: JsonAccessors.h:31
ExtractField

+ Here is the caller graph for this function:

SQLOps to_sql_op ( const std::string &  op_str)
inline

Definition at line 27 of file CalciteDeserializerUtils.h.

References kAND, kBW_EQ, kCAST, kDIVIDE, kEQ, kFUNCTION, kGE, kGT, kIN, kISNOTNULL, kISNULL, kLE, kLT, kMINUS, kMODULO, kMULTIPLY, kNE, kNOT, kOR, kPLUS, and kUNNEST.

Referenced by anonymous_namespace{RelAlgDagBuilder.cpp}::parse_operator().

27  {
28  if (op_str == std::string(">")) {
29  return kGT;
30  }
31  if (op_str == std::string("IS NOT DISTINCT FROM")) {
32  return kBW_EQ;
33  }
34  if (op_str == std::string(">=")) {
35  return kGE;
36  }
37  if (op_str == std::string("<")) {
38  return kLT;
39  }
40  if (op_str == std::string("<=")) {
41  return kLE;
42  }
43  if (op_str == std::string("=")) {
44  return kEQ;
45  }
46  if (op_str == std::string("<>")) {
47  return kNE;
48  }
49  if (op_str == std::string("+")) {
50  return kPLUS;
51  }
52  if (op_str == std::string("-")) {
53  return kMINUS;
54  }
55  if (op_str == std::string("*")) {
56  return kMULTIPLY;
57  }
58  if (op_str == std::string("/")) {
59  return kDIVIDE;
60  }
61  if (op_str == "MOD") {
62  return kMODULO;
63  }
64  if (op_str == std::string("AND")) {
65  return kAND;
66  }
67  if (op_str == std::string("OR")) {
68  return kOR;
69  }
70  if (op_str == std::string("CAST")) {
71  return kCAST;
72  }
73  if (op_str == std::string("NOT")) {
74  return kNOT;
75  }
76  if (op_str == std::string("IS NULL")) {
77  return kISNULL;
78  }
79  if (op_str == std::string("IS NOT NULL")) {
80  return kISNOTNULL;
81  }
82  if (op_str == std::string("PG_UNNEST")) {
83  return kUNNEST;
84  }
85  if (op_str == std::string("PG_ANY") || op_str == std::string("PG_ALL")) {
86  throw std::runtime_error("Invalid use of " + op_str + " operator");
87  }
88  if (op_str == std::string("IN")) {
89  return kIN;
90  }
91  return kFUNCTION;
92 }
Definition: sqldefs.h:35
Definition: sqldefs.h:36
Definition: sqldefs.h:38
Definition: sqldefs.h:49
Definition: sqldefs.h:30
Definition: sqldefs.h:41
Definition: sqldefs.h:37
Definition: sqldefs.h:34
Definition: sqldefs.h:40
Definition: sqldefs.h:32
Definition: sqldefs.h:53
Definition: sqldefs.h:31
Definition: sqldefs.h:33
Definition: sqldefs.h:39

+ Here is the caller graph for this function:

SQLTypes to_sql_type ( const std::string &  type_name)
inline

Definition at line 122 of file CalciteDeserializerUtils.h.

References kARRAY, kBIGINT, kBOOLEAN, kDATE, kDECIMAL, kDOUBLE, kEVAL_CONTEXT_TYPE, kFLOAT, kINT, kINTERVAL_DAY_TIME, kINTERVAL_YEAR_MONTH, kNULLT, kSMALLINT, kTEXT, kTIME, kTIMESTAMP, and kTINYINT.

Referenced by anonymous_namespace{RelAlgDagBuilder.cpp}::parse_literal(), and anonymous_namespace{RelAlgDagBuilder.cpp}::parse_type().

122  {
123  if (type_name == std::string("BIGINT")) {
124  return kBIGINT;
125  }
126  if (type_name == std::string("INTEGER")) {
127  return kINT;
128  }
129  if (type_name == std::string("TINYINT")) {
130  return kTINYINT;
131  }
132  if (type_name == std::string("SMALLINT")) {
133  return kSMALLINT;
134  }
135  if (type_name == std::string("FLOAT")) {
136  return kFLOAT;
137  }
138  if (type_name == std::string("DOUBLE")) {
139  return kDOUBLE;
140  }
141  if (type_name == std::string("DECIMAL")) {
142  return kDECIMAL;
143  }
144  if (type_name == std::string("CHAR") || type_name == std::string("VARCHAR")) {
145  return kTEXT;
146  }
147  if (type_name == std::string("BOOLEAN")) {
148  return kBOOLEAN;
149  }
150  if (type_name == std::string("TIMESTAMP")) {
151  return kTIMESTAMP;
152  }
153  if (type_name == std::string("DATE")) {
154  return kDATE;
155  }
156  if (type_name == std::string("TIME")) {
157  return kTIME;
158  }
159  if (type_name == std::string("NULL")) {
160  return kNULLT;
161  }
162  if (type_name == std::string("ARRAY")) {
163  return kARRAY;
164  }
165  if (type_name == std::string("INTERVAL_DAY") ||
166  type_name == std::string("INTERVAL_HOUR") ||
167  type_name == std::string("INTERVAL_MINUTE") ||
168  type_name == std::string("INTERVAL_SECOND")) {
169  return kINTERVAL_DAY_TIME;
170  }
171  if (type_name == std::string("INTERVAL_MONTH") ||
172  type_name == std::string("INTERVAL_YEAR")) {
173  return kINTERVAL_YEAR_MONTH;
174  }
175  if (type_name == std::string("ANY")) {
176  return kEVAL_CONTEXT_TYPE;
177  }
178 
179  throw std::runtime_error("Unsupported type: " + type_name);
180 }
Definition: sqltypes.h:51
Definition: sqltypes.h:54
Definition: sqltypes.h:55
Definition: sqltypes.h:47

+ Here is the caller graph for this function: