tsclient.h 13.3 KB
Newer Older
H
hzcheng 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
/*
 * Copyright (c) 2019 TAOS Data, Inc. <jhtao@taosdata.com>
 *
 * This program is free software: you can use, redistribute, and/or modify
 * it under the terms of the GNU Affero General Public License, version 3
 * or later ("AGPL"), as published by the Free Software Foundation.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
 * FITNESS FOR A PARTICULAR PURPOSE.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 */

#ifndef TDENGINE_TSCLIENT_H
#define TDENGINE_TSCLIENT_H

#ifdef __cplusplus
extern "C" {
#endif

S
slguan 已提交
23
#include "os.h"
24

H
hzcheng 已提交
25
#include "taos.h"
26
#include "taosdef.h"
H
hzcheng 已提交
27
#include "taosmsg.h"
H
hjxilinx 已提交
28
#include "tarray.h"
S
slguan 已提交
29
#include "tglobal.h"
30
#include "tsqlfunction.h"
H
hjxilinx 已提交
31 32
#include "tutil.h"

33
#include "qExecutor.h"
H
hjxilinx 已提交
34 35 36
#include "qsqlparser.h"
#include "qsqltype.h"
#include "qtsbuf.h"
H
hzcheng 已提交
37 38 39

// forward declaration
struct SSqlInfo;
H
hjxilinx 已提交
40 41 42 43 44 45 46
struct SLocalReducer;

// data source from sql string or from file
enum {
  DATA_FROM_SQL_STRING = 1,
  DATA_FROM_DATA_FILE = 2,
};
H
hzcheng 已提交
47

H
hjxilinx 已提交
48
typedef struct STableComInfo {
H
hjxilinx 已提交
49 50 51
  uint8_t numOfTags;
  uint8_t precision;
  int16_t numOfColumns;
B
Bomin Zhang 已提交
52
  int32_t rowSize;
H
hjxilinx 已提交
53
} STableComInfo;
H
hjxilinx 已提交
54 55

typedef struct STableMeta {
H
Haojun Liao 已提交
56
  STableComInfo tableInfo;
H
hjxilinx 已提交
57 58
  uint8_t       tableType;
  int16_t       sversion;
59
  int16_t       tversion;
H
hjxilinx 已提交
60
  SCMVgroupInfo vgroupInfo;
H
hjxilinx 已提交
61 62 63
  int32_t       sid;       // the index of one table in a virtual node
  uint64_t      uid;       // unique id of a table
  SSchema       schema[];  // if the table is TSDB_CHILD_TABLE, schema is acquired by super table meta info
H
hjxilinx 已提交
64 65 66
} STableMeta;

typedef struct STableMetaInfo {
67
  STableMeta *  pTableMeta;      // table meta, cached in client side and acquired by name
H
hjxilinx 已提交
68
  SVgroupsInfo *vgroupList;
69 70
  SArray       *pVgroupTables;   // SArray<SVgroupTableInfo>
  
H
hjxilinx 已提交
71
  /*
H
hjxilinx 已提交
72 73
   * 1. keep the vgroup index during the multi-vnode super table projection query
   * 2. keep the vgroup index for multi-vnode insertion
H
hjxilinx 已提交
74
   */
H
hjxilinx 已提交
75
  int32_t vgroupIndex;
H
hjxilinx 已提交
76
  char    name[TSDB_TABLE_ID_LEN];        // (super) table name
77
  SArray* tagColList;                     // SArray<SColumn*>, involved tag columns
H
hjxilinx 已提交
78
} STableMetaInfo;
H
hzcheng 已提交
79

S
slguan 已提交
80 81
/* the structure for sql function in select clause */
typedef struct SSqlExpr {
H
hjxilinx 已提交
82 83 84 85 86 87
  char      aliasName[TSDB_COL_NAME_LEN];  // as aliasName
  SColIndex colInfo;
  int64_t   uid;            // refactor use the pointer
  int16_t   functionId;     // function id in aAgg array
  int16_t   resType;        // return value type
  int16_t   resBytes;       // length of return value
88
  int32_t   interBytes;  // inter result buffer size
H
hjxilinx 已提交
89 90 91
  int16_t   numOfParams;    // argument value of each function
  tVariant  param[3];       // parameters are not more than 3
  int32_t   offset;         // sub result column value of arithmetic expression.
H
hzcheng 已提交
92 93
} SSqlExpr;

H
hjxilinx 已提交
94 95 96 97 98
typedef struct SColumnIndex {
  int16_t tableIndex;
  int16_t columnIndex;
} SColumnIndex;

H
hjxilinx 已提交
99 100
typedef struct SFieldSupInfo {
  bool            visible;
H
hjxilinx 已提交
101
  SExprInfo      *pArithExprInfo;
H
hjxilinx 已提交
102
  SSqlExpr *      pSqlExpr;
H
hjxilinx 已提交
103
} SFieldSupInfo;
S
slguan 已提交
104

H
hjxilinx 已提交
105
typedef struct SFieldInfo {
H
hjxilinx 已提交
106 107 108
  int16_t numOfOutput;   // number of column in result
  SArray *pFields;       // SArray<TAOS_FIELD>
  SArray *pSupportInfo;  // SArray<SFieldSupInfo>
H
hzcheng 已提交
109 110
} SFieldInfo;

111
typedef struct SColumn {
S
slguan 已提交
112 113 114
  SColumnIndex       colIndex;
  int32_t            numOfFilters;
  SColumnFilterInfo *filterInfo;
115
} SColumn;
H
hzcheng 已提交
116

S
slguan 已提交
117 118
typedef struct SCond {
  uint64_t uid;
H
hjxilinx 已提交
119
  int32_t  len;  // length of tag query condition data
H
hjxilinx 已提交
120
  char *   cond;
S
slguan 已提交
121 122 123
} SCond;

typedef struct SJoinNode {
S
slguan 已提交
124
  char     tableId[TSDB_TABLE_ID_LEN];
S
slguan 已提交
125 126 127 128 129 130 131 132 133 134
  uint64_t uid;
  int16_t  tagCol;
} SJoinNode;

typedef struct SJoinInfo {
  bool      hasJoin;
  SJoinNode left;
  SJoinNode right;
} SJoinInfo;

H
hzcheng 已提交
135
typedef struct STagCond {
S
slguan 已提交
136 137 138 139 140 141 142 143 144 145
  // relation between tbname list and query condition, including : TK_AND or TK_OR
  int16_t relType;

  // tbname query condition, only support tbname query condition on one table
  SCond tbnameCond;

  // join condition, only support two tables join currently
  SJoinInfo joinInfo;

  // for different table, the query condition must be seperated
H
hjxilinx 已提交
146
  SArray *pCond;
H
hzcheng 已提交
147 148
} STagCond;

S
slguan 已提交
149
typedef struct SParamInfo {
H
hjxilinx 已提交
150 151 152 153
  int32_t  idx;
  char     type;
  uint8_t  timePrec;
  short    bytes;
S
slguan 已提交
154 155 156
  uint32_t offset;
} SParamInfo;

S
slguan 已提交
157
typedef struct STableDataBlocks {
S
slguan 已提交
158
  char    tableId[TSDB_TABLE_ID_LEN];
159 160
  int8_t  tsSource;     // where does the UNIX timestamp come from, server or client
  bool    ordered;      // if current rows are ordered or not
H
hjxilinx 已提交
161
  int64_t vgId;         // virtual group id
162
  int64_t prevTS;       // previous timestamp, recorded to decide if the records array is ts ascending
S
slguan 已提交
163
  int32_t numOfTables;  // number of tables in current submit block
164 165

  int32_t  rowSize;  // row size for current table
S
slguan 已提交
166
  uint32_t nAllocSize;
H
hjxilinx 已提交
167
  uint32_t headerSize;  // header for metadata (submit metadata)
S
slguan 已提交
168
  uint32_t size;
169

H
hjxilinx 已提交
170 171 172 173
  /*
   * the metermeta for current table, the metermeta will be used during submit stage, keep a ref
   * to avoid it to be removed from cache
   */
H
hjxilinx 已提交
174
  STableMeta *pTableMeta;
175

H
hzcheng 已提交
176 177 178 179
  union {
    char *filename;
    char *pData;
  };
S
slguan 已提交
180 181

  // for parameter ('?') binding
H
hjxilinx 已提交
182 183 184
  uint32_t    numOfAllocedParams;
  uint32_t    numOfParams;
  SParamInfo *params;
S
slguan 已提交
185
} STableDataBlocks;
H
hzcheng 已提交
186

H
hjxilinx 已提交
187
typedef struct SDataBlockList {  // todo remove
H
hjxilinx 已提交
188 189
  uint32_t           nSize;
  uint32_t           nAlloc;
S
slguan 已提交
190
  STableDataBlocks **pData;
H
hzcheng 已提交
191 192
} SDataBlockList;

193
typedef struct SQueryInfo {
194
  int16_t  command;  // the command may be different for each subclause, so keep it seperately.
H
hjxilinx 已提交
195
  uint32_t type;     // query/insert/import type
H
hjxilinx 已提交
196
  char     slidingTimeUnit;
197

H
hjxilinx 已提交
198
  STimeWindow     window;
199
  int64_t         intervalTime;  // aggregation time interval
H
hjxilinx 已提交
200 201
  int64_t         slidingTime;   // sliding window in mseconds
  SSqlGroupbyExpr groupbyExpr;   // group by tags info
202

H
hjxilinx 已提交
203
  SArray *         colList;      // SArray<SColumn*>
204
  SFieldInfo       fieldsInfo;
H
hjxilinx 已提交
205
  SArray *         exprList;    // SArray<SSqlExpr*>
206 207 208 209
  SLimitVal        limit;
  SLimitVal        slimit;
  STagCond         tagCond;
  SOrderVal        order;
210
  int16_t          fillType;  // interpolate type
211
  int16_t          numOfTables;
H
hjxilinx 已提交
212
  STableMetaInfo **pTableMetaInfo;
213
  struct STSBuf *  tsBuf;
214
  int64_t *        fillVal;      // default value for interpolation
215
  char *           msg;          // pointer to the pCmd->payload to keep error message temporarily
216
  int64_t          clauseLimit;  // limit for current sub clause
H
hjxilinx 已提交
217

218
  // offset value in the original sql expression, NOT sent to virtual node, only applied at client side
219
  int64_t          prjOffset;
220 221
} SQueryInfo;

H
hzcheng 已提交
222
typedef struct {
223 224
  int     command;
  uint8_t msgType;
S
slguan 已提交
225

B
Bomin Zhang 已提交
226 227
  bool   autoCreated;        // if the table is missing, on-the-fly create it. during getmeterMeta
  int8_t dataSourceType;     // load data from file or not
H
hjxilinx 已提交
228

229 230 231 232
  union {
    int32_t count;
    int32_t numOfTablesInSubmit;
  };
H
hzcheng 已提交
233

234 235 236 237 238 239
  int32_t      clauseIndex;  // index of multiple subclause query
  int8_t       parseFinished;
  short        numOfCols;
  uint32_t     allocSize;
  char *       payload;
  int32_t      payloadLen;
240 241
  SQueryInfo **pQueryInfo;
  int32_t      numOfClause;
H
hjxilinx 已提交
242 243 244 245 246

  SDataBlockList *pDataBlocks;  // submit data blocks after parsing sql
  char *          curSql;       // current sql, resume position of sql after parsing paused
  void *          pTableList;   // referred table involved in sql

S
slguan 已提交
247 248 249
  // for parameter ('?') binding and batch processing
  int32_t batchSize;
  int32_t numOfParams;
H
hzcheng 已提交
250 251 252 253 254 255 256 257
} SSqlCmd;

typedef struct SResRec {
  int numOfRows;
  int numOfTotal;
} SResRec;

typedef struct {
H
hjxilinx 已提交
258 259
  int64_t               numOfRows;                  // num of results in current retrieved
  int64_t               numOfTotal;                 // num of total results
H
Haojun Liao 已提交
260
  int64_t               numOfClauseTotal;           // num of total result in current subclause
H
hjxilinx 已提交
261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276
  char *                pRsp;
  int32_t               rspType;
  int32_t               rspLen;
  uint64_t              qhandle;
  int64_t               uid;
  int64_t               useconds;
  int64_t               offset;  // offset value from vnode during projection query of stable
  int32_t               row;
  int16_t               numOfCols;
  int16_t               precision;
  bool                  completed;
  int32_t               code;
  int32_t               numOfGroups;
  SResRec *             pGroupRec;
  char *                data;
  void **               tsrow;
277
  int32_t*              length;  // length for each field for current row
H
hjxilinx 已提交
278 279
  char **               buffer;  // Buffer used to put multibytes encoded using unicode (wchar_t)
  SColumnIndex *        pColumnIndex;
280 281
  SArithmeticSupport*   pArithSup;   // support the arithmetic expression calculation on agg functions
  
H
hzcheng 已提交
282 283 284
  struct SLocalReducer *pLocalReducer;
} SSqlRes;

H
hjxilinx 已提交
285
typedef struct STscObj {
H
hjxilinx 已提交
286 287 288 289 290 291 292 293 294
  void *             signature;
  void *             pTimer;
  char               user[TSDB_USER_LEN];
  char               pass[TSDB_KEY_LEN];
  char               acctId[TSDB_DB_NAME_LEN];
  char               db[TSDB_TABLE_ID_LEN];
  char               sversion[TSDB_VERSION_LEN];
  char               writeAuth : 1;
  char               superAuth : 1;
S
Shengliang Guan 已提交
295
  uint32_t           connId;
H
hjxilinx 已提交
296 297
  struct SSqlObj *   pHb;
  struct SSqlObj *   sqlList;
H
hjxilinx 已提交
298
  struct SSqlStream *streamList;
299
  void*              pDnodeConn;
H
hjxilinx 已提交
300
  pthread_mutex_t    mutex;
H
hzcheng 已提交
301 302
} STscObj;

303
typedef struct SSqlObj {
H
hzcheng 已提交
304 305 306 307
  void *   signature;
  STscObj *pTscObj;
  void (*fp)();
  void (*fetchFp)();
H
hjxilinx 已提交
308 309 310 311 312 313 314 315 316 317 318
  void *           param;
  int64_t          stime;
  uint32_t         queryId;
  void *           pStream;
  void *           pSubscription;
  char *           sqlstr;
  char             retry;
  char             maxRetry;
  SRpcIpSet        ipList;
  char             freed : 4;
  char             listed : 4;
H
Hui Li 已提交
319
  uint32_t         insertType;
H
hjxilinx 已提交
320 321 322
  tsem_t           rspSem;
  SSqlCmd          cmd;
  SSqlRes          res;
H
Haojun Liao 已提交
323
  uint16_t         numOfSubs;
324 325
  struct SSqlObj **pSubs;
  struct SSqlObj * prev, *next;
H
hzcheng 已提交
326 327
} SSqlObj;

H
hjxilinx 已提交
328
typedef struct SSqlStream {
H
hzcheng 已提交
329 330 331 332 333 334
  SSqlObj *pSql;
  uint32_t streamId;
  char     listed;
  int64_t  num;  // number of computing count

  /*
S
slguan 已提交
335
   * keep the number of current result in computing,
H
hzcheng 已提交
336 337 338 339 340 341 342
   * the value will be set to 0 before set timer for next computing
   */
  int64_t numOfRes;

  int64_t useconds;  // total  elapsed time
  int64_t ctime;     // stream created time
  int64_t stime;     // stream next executed time
S
slguan 已提交
343
  int64_t etime;     // stream end query time, when time is larger then etime, the stream will be closed
H
hzcheng 已提交
344 345
  int64_t interval;
  int64_t slidingTime;
346
  int16_t precision;
H
hzcheng 已提交
347 348 349 350 351
  void *  pTimer;

  void (*fp)();
  void *param;

S
slguan 已提交
352
  void (*callback)(void *);  // Callback function when stream is stopped from client level
H
hjxilinx 已提交
353
  struct SSqlStream *prev, *next;
H
hzcheng 已提交
354 355
} SSqlStream;

356
int32_t tscInitRpc(const char *user, const char *secret, void** pDnodeConn);
H
hjxilinx 已提交
357
void    tscInitMsgsFp();
S
slguan 已提交
358

359
int tsParseSql(SSqlObj *pSql, bool multiVnodeInsertion);
H
hzcheng 已提交
360

J
jtao1735 已提交
361
void tscProcessMsgFromServer(SRpcMsg *rpcMsg, SRpcIpSet *pIpSet);
S
slguan 已提交
362
int  tscProcessSql(SSqlObj *pSql);
H
hzcheng 已提交
363

S
slguan 已提交
364
int  tscRenewMeterMeta(SSqlObj *pSql, char *tableId);
H
hzcheng 已提交
365
void tscQueueAsyncRes(SSqlObj *pSql);
S
slguan 已提交
366

H
[td-99]  
hjxilinx 已提交
367
void tscQueueAsyncError(void(*fp), void *param, int32_t code);
H
hzcheng 已提交
368 369 370 371 372

int tscProcessLocalCmd(SSqlObj *pSql);
int tscCfgDynamicOptions(char *msg);
int taos_retrieve(TAOS_RES *res);

H
hjxilinx 已提交
373 374
int32_t tscTansformSQLFuncForSTableQuery(SQueryInfo *pQueryInfo);
void    tscRestoreSQLFuncForSTableQuery(SQueryInfo *pQueryInfo);
H
hzcheng 已提交
375

376
int32_t tscCreateResPointerInfo(SSqlRes *pRes, SQueryInfo *pQueryInfo);
H
hjxilinx 已提交
377
void    tscDestroyResPointerInfo(SSqlRes *pRes);
H
hzcheng 已提交
378

379
void tscResetSqlCmdObj(SSqlCmd *pCmd);
H
hzcheng 已提交
380

weixin_48148422's avatar
weixin_48148422 已提交
381 382 383 384
/**
 * free query result of the sql object
 * @param pObj
 */
H
hjxilinx 已提交
385
void tscFreeSqlResult(SSqlObj *pSql);
weixin_48148422's avatar
weixin_48148422 已提交
386

H
hzcheng 已提交
387 388 389 390 391
/**
 * only free part of resources allocated during query.
 * Note: this function is multi-thread safe.
 * @param pObj
 */
H
hjxilinx 已提交
392
void tscPartiallyFreeSqlObj(SSqlObj *pObj);
H
hzcheng 已提交
393 394 395 396 397 398 399 400 401 402

/**
 * free sql object, release allocated resource
 * @param pObj  Free metric/meta information, dynamically allocated payload, and
 * response buffer, object itself
 */
void tscFreeSqlObj(SSqlObj *pObj);

void tscCloseTscObj(STscObj *pObj);

H
hjxilinx 已提交
403 404
TAOS *taos_connect_a(char *ip, char *user, char *pass, char *db, uint16_t port, void (*fp)(void *, TAOS_RES *, int),
                     void *param, void **taos);
H
Hui Li 已提交
405
void waitForQueryRsp(void *param, TAOS_RES *tres, int code) ;
H
hjxilinx 已提交
406 407

void doAsyncQuery(STscObj *pObj, SSqlObj *pSql, void (*fp)(), void *param, const char *sqlstr, size_t sqlLen);
408

409
void tscProcessMultiVnodesInsertFromFile(SSqlObj *pSql);
H
hjxilinx 已提交
410
void tscKillSTableQuery(SSqlObj *pSql);
411
void tscInitResObjForLocalQuery(SSqlObj *pObj, int32_t numOfRes, int32_t rowLen);
H
Haojun Liao 已提交
412
bool tscIsUpdateQuery(SSqlObj* pSql);
413
bool tscHasReachLimitation(SQueryInfo *pQueryInfo, SSqlRes *pRes);
H
hjxilinx 已提交
414

415
char *tscGetErrorMsgPayload(SSqlCmd *pCmd);
416

H
hjxilinx 已提交
417
int32_t tscInvalidSQLErrMsg(char *msg, const char *additionalInfo, const char *sql);
H
hzcheng 已提交
418

H
hjxilinx 已提交
419 420
void    tscQueueAsyncFreeResult(SSqlObj *pSql);
int32_t tscToSQLCmd(SSqlObj *pSql, struct SSqlInfo *pInfo);
421
void    tscGetResultColumnChr(SSqlRes *pRes, SFieldInfo* pFieldInfo, int32_t column);
H
hjxilinx 已提交
422 423 424 425 426 427 428 429 430 431

extern void *    tscCacheHandle;
extern void *    tscTmr;
extern void *    tscQhandle;
extern int       tscKeepConn[];
extern int       tsInsertHeadSize;
extern int       tscNumOfThreads;
extern SRpcIpSet tscMgmtIpSet;

extern int (*tscBuildMsg[TSDB_SQL_MAX])(SSqlObj *pSql, SSqlInfo *pInfo);
H
hzcheng 已提交
432

433 434
typedef void (*__async_cb_func_t)(void *param, TAOS_RES *tres, int numOfRows);

weixin_48148422's avatar
weixin_48148422 已提交
435 436 437
int32_t tscCompareTidTags(const void* p1, const void* p2);
void tscBuildVgroupTableInfo(STableMetaInfo* pTableMetaInfo, SArray* tables);

H
hzcheng 已提交
438 439 440 441 442
#ifdef __cplusplus
}
#endif

#endif