queryUtil.c 13.1 KB
Newer Older
L
Liu Jicong 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
/*
 * 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/>.
 */

16
#include "os.h"
H
Haojun Liao 已提交
17 18
#include "query.h"
#include "tglobal.h"
L
Liu Jicong 已提交
19
#include "tmsg.h"
20
#include "trpc.h"
L
Liu Jicong 已提交
21
#include "tsched.h"
dengyihao's avatar
dengyihao 已提交
22
// clang-format off
D
dapan1121 已提交
23
#include "cJSON.h"
24

L
Liu Jicong 已提交
25 26
#define VALIDNUMOFCOLS(x) ((x) >= TSDB_MIN_COLUMNS && (x) <= TSDB_MAX_COLUMNS)
#define VALIDNUMOFTAGS(x) ((x) >= 0 && (x) <= TSDB_MAX_TAGS)
27 28 29

static struct SSchema _s = {
    .colId = TSDB_TBNAME_COLUMN_INDEX,
L
Liu Jicong 已提交
30
    .type = TSDB_DATA_TYPE_BINARY,
31 32 33 34
    .bytes = TSDB_TABLE_NAME_LEN + VARSTR_HEADER_SIZE,
    .name = "tbname",
};

L
Liu Jicong 已提交
35
const SSchema* tGetTbnameColumnSchema() { return &_s; }
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62

static bool doValidateSchema(SSchema* pSchema, int32_t numOfCols, int32_t maxLen) {
  int32_t rowLen = 0;

  for (int32_t i = 0; i < numOfCols; ++i) {
    // 1. valid types
    if (!isValidDataType(pSchema[i].type)) {
      return false;
    }

    // 2. valid length for each type
    if (pSchema[i].type == TSDB_DATA_TYPE_BINARY) {
      if (pSchema[i].bytes > TSDB_MAX_BINARY_LEN) {
        return false;
      }
    } else if (pSchema[i].type == TSDB_DATA_TYPE_NCHAR) {
      if (pSchema[i].bytes > TSDB_MAX_NCHAR_LEN) {
        return false;
      }
    } else {
      if (pSchema[i].bytes != tDataTypes[pSchema[i].type].bytes) {
        return false;
      }
    }

    // 3. valid column names
    for (int32_t j = i + 1; j < numOfCols; ++j) {
D
dapan1121 已提交
63
      if (strncmp(pSchema[i].name, pSchema[j].name, sizeof(pSchema[i].name) - 1) == 0) {
64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96
        return false;
      }
    }

    rowLen += pSchema[i].bytes;
  }

  return rowLen <= maxLen;
}

bool tIsValidSchema(struct SSchema* pSchema, int32_t numOfCols, int32_t numOfTags) {
  if (!VALIDNUMOFCOLS(numOfCols)) {
    return false;
  }

  if (!VALIDNUMOFTAGS(numOfTags)) {
    return false;
  }

  /* first column must be the timestamp, which is a primary key */
  if (pSchema[0].type != TSDB_DATA_TYPE_TIMESTAMP) {
    return false;
  }

  if (!doValidateSchema(pSchema, numOfCols, TSDB_MAX_BYTES_PER_ROW)) {
    return false;
  }

  if (!doValidateSchema(&pSchema[numOfCols], numOfTags, TSDB_MAX_TAGS_LEN)) {
    return false;
  }

  return true;
H
Haojun Liao 已提交
97 98
}

D
dapan1121 已提交
99
static SSchedQueue pTaskQueue = {0};
H
Haojun Liao 已提交
100 101

int32_t initTaskQueue() {
S
Shengliang Guan 已提交
102
  int32_t queueSize = tsMaxShellConns * 2;
D
dapan1121 已提交
103 104
  void *p = taosInitScheduler(queueSize, tsNumOfTaskQueueThreads, "tsc", &pTaskQueue);
  if (NULL == p) {
H
Haojun Liao 已提交
105 106 107 108
    qError("failed to init task queue");
    return -1;
  }

S
Shengliang Guan 已提交
109
  qDebug("task queue is initialized, numOfThreads: %d", tsNumOfTaskQueueThreads);
L
Liu Jicong 已提交
110
  return 0;
H
Haojun Liao 已提交
111 112 113
}

int32_t cleanupTaskQueue() {
D
dapan1121 已提交
114
  taosCleanUpScheduler(&pTaskQueue);
L
Liu Jicong 已提交
115
  return 0;
H
Haojun Liao 已提交
116 117 118 119 120
}

static void execHelper(struct SSchedMsg* pSchedMsg) {
  assert(pSchedMsg != NULL && pSchedMsg->ahandle != NULL);

L
Liu Jicong 已提交
121 122
  __async_exec_fn_t execFn = (__async_exec_fn_t)pSchedMsg->ahandle;
  int32_t           code = execFn(pSchedMsg->thandle);
H
Haojun Liao 已提交
123
  if (code != 0 && pSchedMsg->msg != NULL) {
L
Liu Jicong 已提交
124
    *(int32_t*)pSchedMsg->msg = code;
H
Haojun Liao 已提交
125 126 127 128 129 130 131
  }
}

int32_t taosAsyncExec(__async_exec_fn_t execFn, void* execParam, int32_t* code) {
  assert(execFn != NULL);

  SSchedMsg schedMsg = {0};
L
Liu Jicong 已提交
132
  schedMsg.fp = execHelper;
H
Haojun Liao 已提交
133 134
  schedMsg.ahandle = execFn;
  schedMsg.thandle = execParam;
L
Liu Jicong 已提交
135
  schedMsg.msg = code;
H
Haojun Liao 已提交
136

dengyihao's avatar
dengyihao 已提交
137
  return taosScheduleTask(&pTaskQueue, &schedMsg);
H
Haojun Liao 已提交
138
}
139

D
dapan1121 已提交
140 141 142 143 144 145 146 147 148
void destroySendMsgInfo(SMsgSendInfo* pMsgBody) {
  assert(pMsgBody != NULL);
  taosMemoryFreeClear(pMsgBody->target.dbFName);
  taosMemoryFreeClear(pMsgBody->msgInfo.pData);
  if (pMsgBody->paramFreeFp) {
    (*pMsgBody->paramFreeFp)(pMsgBody->param);
  }
  taosMemoryFreeClear(pMsgBody);
}
dengyihao's avatar
dengyihao 已提交
149 150 151 152 153 154
void destroyAhandle(void *ahandle) {
  SMsgSendInfo *pSendInfo = ahandle;
  if (pSendInfo == NULL) return;

  destroySendMsgInfo(pSendInfo);
}
D
dapan1121 已提交
155

D
dapan1121 已提交
156
int32_t asyncSendMsgToServerExt(void* pTransporter, SEpSet* epSet, int64_t* pTransporterId, SMsgSendInfo* pInfo,
157
                                bool persistHandle, void* rpcCtx) {
L
Liu Jicong 已提交
158
  char* pMsg = rpcMallocCont(pInfo->msgInfo.len);
159
  if (NULL == pMsg) {
L
Liu Jicong 已提交
160
    qError("0x%" PRIx64 " msg:%s malloc failed", pInfo->requestId, TMSG_INFO(pInfo->msgType));
D
dapan1121 已提交
161
    destroySendMsgInfo(pInfo);
162
    terrno = TSDB_CODE_TSC_OUT_OF_MEMORY;
163
    return terrno;
164 165 166
  }

  memcpy(pMsg, pInfo->msgInfo.pData, pInfo->msgInfo.len);
dengyihao's avatar
dengyihao 已提交
167 168 169 170 171 172 173 174 175
  SRpcMsg rpcMsg = {
    .msgType = pInfo->msgType,
    .pCont = pMsg,
    .contLen = pInfo->msgInfo.len,
    .info.ahandle = (void*)pInfo,
    .info.handle = pInfo->msgInfo.handle,
    .info.persistHandle = persistHandle, 
    .code = 0
  };
dengyihao's avatar
dengyihao 已提交
176
  TRACE_SET_ROOTID(&rpcMsg.info.traceId, pInfo->requestId);
D
dapan1121 已提交
177 178 179 180 181
  int code = rpcSendRequestWithCtx(pTransporter, epSet, &rpcMsg, pTransporterId, rpcCtx);
  if (code) {
    destroySendMsgInfo(pInfo);
  }
  return code;
L
Liu Jicong 已提交
182
}
D
dapan1121 已提交
183

D
dapan1121 已提交
184
int32_t asyncSendMsgToServer(void* pTransporter, SEpSet* epSet, int64_t* pTransporterId, SMsgSendInfo* pInfo) {
185
  return asyncSendMsgToServerExt(pTransporter, epSet, pTransporterId, pInfo, false, NULL);
D
dapan1121 已提交
186 187
}

dengyihao's avatar
dengyihao 已提交
188
char* jobTaskStatusStr(int32_t status) {
D
dapan1121 已提交
189 190 191
  switch (status) {
    case JOB_TASK_STATUS_NULL:
      return "NULL";
D
dapan1121 已提交
192 193 194
    case JOB_TASK_STATUS_INIT:
      return "INIT";
    case JOB_TASK_STATUS_EXEC:
D
dapan1121 已提交
195
      return "EXECUTING";
D
dapan1121 已提交
196
    case JOB_TASK_STATUS_PART_SUCC:
D
dapan1121 已提交
197
      return "PARTIAL_SUCCEED";
D
dapan1121 已提交
198
    case JOB_TASK_STATUS_SUCC:
D
dapan1121 已提交
199
      return "SUCCEED";
D
dapan1121 已提交
200
    case JOB_TASK_STATUS_FAIL:
D
dapan1121 已提交
201
      return "FAILED";
D
dapan1121 已提交
202
    case JOB_TASK_STATUS_DROP:
D
dapan1121 已提交
203 204 205 206 207 208 209
      return "DROPPING";
    default:
      break;
  }

  return "UNKNOWN";
}
D
dapan1121 已提交
210

D
dapan1121 已提交
211
#if 0
212
SSchema createSchema(int8_t type, int32_t bytes, col_id_t colId, const char* name) {
D
dapan1121 已提交
213
  SSchema s = {0};
dengyihao's avatar
dengyihao 已提交
214
  s.type = type;
D
dapan1121 已提交
215 216 217 218 219 220
  s.bytes = bytes;
  s.colId = colId;

  tstrncpy(s.name, name, tListLen(s.name));
  return s;
}
D
dapan1121 已提交
221
#endif
D
dapan1121 已提交
222

223 224 225 226 227
void freeSTableMetaRspPointer(void *p) {
  tFreeSTableMetaRsp(*(void**)p);
  taosMemoryFreeClear(*(void**)p);
}

D
dapan1121 已提交
228
void destroyQueryExecRes(SExecResult* pRes) {
D
dapan1121 已提交
229 230 231 232 233
  if (NULL == pRes || NULL == pRes->res) {
    return;
  }

  switch (pRes->msgType) {
234
    case TDMT_VND_CREATE_TABLE: {
235
      taosArrayDestroyEx((SArray*)pRes->res, freeSTableMetaRspPointer);
236 237 238
      break;
    }
    case TDMT_MND_CREATE_STB:
D
dapan1121 已提交
239 240
    case TDMT_VND_ALTER_TABLE:
    case TDMT_MND_ALTER_STB: {
241
      tFreeSTableMetaRsp(pRes->res);
D
dapan1121 已提交
242 243 244 245 246 247
      taosMemoryFreeClear(pRes->res);
      break;
    }
    case TDMT_VND_SUBMIT: {
      tFreeSSubmitRsp((SSubmitRsp*)pRes->res);
      break;
dengyihao's avatar
dengyihao 已提交
248
    }
D
dapan1121 已提交
249 250
    case TDMT_SCH_QUERY: 
    case TDMT_SCH_MERGE_QUERY: {
D
dapan1121 已提交
251 252 253 254 255 256 257
      taosArrayDestroy((SArray*)pRes->res);
      break;
    }
    default:
      qError("invalid exec result for request type %d", pRes->msgType);
  }
}
dengyihao's avatar
dengyihao 已提交
258
// clang-format on
D
dapan1121 已提交
259

dengyihao's avatar
dengyihao 已提交
260
int32_t dataConverToStr(char* str, int type, void* buf, int32_t bufSize, int32_t* len) {
D
dapan1121 已提交
261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298
  int32_t n = 0;

  switch (type) {
    case TSDB_DATA_TYPE_NULL:
      n = sprintf(str, "null");
      break;

    case TSDB_DATA_TYPE_BOOL:
      n = sprintf(str, (*(int8_t*)buf) ? "true" : "false");
      break;

    case TSDB_DATA_TYPE_TINYINT:
      n = sprintf(str, "%d", *(int8_t*)buf);
      break;

    case TSDB_DATA_TYPE_SMALLINT:
      n = sprintf(str, "%d", *(int16_t*)buf);
      break;

    case TSDB_DATA_TYPE_INT:
      n = sprintf(str, "%d", *(int32_t*)buf);
      break;

    case TSDB_DATA_TYPE_BIGINT:
    case TSDB_DATA_TYPE_TIMESTAMP:
      n = sprintf(str, "%" PRId64, *(int64_t*)buf);
      break;

    case TSDB_DATA_TYPE_FLOAT:
      n = sprintf(str, "%e", GET_FLOAT_VAL(buf));
      break;

    case TSDB_DATA_TYPE_DOUBLE:
      n = sprintf(str, "%e", GET_DOUBLE_VAL(buf));
      break;

    case TSDB_DATA_TYPE_BINARY:
      if (bufSize < 0) {
dengyihao's avatar
dengyihao 已提交
299
        //        tscError("invalid buf size");
D
dapan1121 已提交
300 301 302 303 304 305 306 307
        return TSDB_CODE_TSC_INVALID_VALUE;
      }

      *str = '"';
      memcpy(str + 1, buf, bufSize);
      *(str + bufSize + 1) = '"';
      n = bufSize + 2;
      break;
wmmhello's avatar
wmmhello 已提交
308 309 310 311 312
    case TSDB_DATA_TYPE_NCHAR:
      if (bufSize < 0) {
        //        tscError("invalid buf size");
        return TSDB_CODE_TSC_INVALID_VALUE;
      }
D
dapan1121 已提交
313

wmmhello's avatar
wmmhello 已提交
314
      *str = '"';
dengyihao's avatar
dengyihao 已提交
315
      int32_t length = taosUcs4ToMbs((TdUcs4*)buf, bufSize, str + 1);
wmmhello's avatar
wmmhello 已提交
316 317 318 319 320 321
      if (length <= 0) {
        return TSDB_CODE_TSC_INVALID_VALUE;
      }
      *(str + length + 1) = '"';
      n = length + 2;
      break;
D
dapan1121 已提交
322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338
    case TSDB_DATA_TYPE_UTINYINT:
      n = sprintf(str, "%d", *(uint8_t*)buf);
      break;

    case TSDB_DATA_TYPE_USMALLINT:
      n = sprintf(str, "%d", *(uint16_t*)buf);
      break;

    case TSDB_DATA_TYPE_UINT:
      n = sprintf(str, "%u", *(uint32_t*)buf);
      break;

    case TSDB_DATA_TYPE_UBIGINT:
      n = sprintf(str, "%" PRIu64, *(uint64_t*)buf);
      break;

    default:
dengyihao's avatar
dengyihao 已提交
339
      //      tscError("unsupported type:%d", type);
D
dapan1121 已提交
340 341 342
      return TSDB_CODE_TSC_INVALID_VALUE;
  }

dengyihao's avatar
dengyihao 已提交
343
  if (len) *len = n;
D
dapan1121 已提交
344 345 346 347

  return TSDB_CODE_SUCCESS;
}

D
dapan1121 已提交
348
char* parseTagDatatoJson(void* p) {
dengyihao's avatar
dengyihao 已提交
349
  char*   string = NULL;
D
dapan1121 已提交
350
  SArray* pTagVals = NULL;
dengyihao's avatar
dengyihao 已提交
351
  cJSON*  json = NULL;
D
dapan1121 已提交
352 353 354 355 356
  if (tTagToValArray((const STag*)p, &pTagVals) != 0) {
    goto end;
  }

  int16_t nCols = taosArrayGetSize(pTagVals);
wmmhello's avatar
wmmhello 已提交
357 358 359
  if (nCols == 0) {
    goto end;
  }
dengyihao's avatar
dengyihao 已提交
360
  char tagJsonKey[256] = {0};
wmmhello's avatar
wmmhello 已提交
361 362 363 364
  json = cJSON_CreateObject();
  if (json == NULL) {
    goto end;
  }
D
dapan1121 已提交
365 366 367
  for (int j = 0; j < nCols; ++j) {
    STagVal* pTagVal = (STagVal*)taosArrayGet(pTagVals, j);
    // json key  encode by binary
D
dapan1121 已提交
368
    tstrncpy(tagJsonKey, pTagVal->pKey, sizeof(tagJsonKey));
D
dapan1121 已提交
369 370 371 372 373 374 375 376 377 378 379 380 381 382 383
    // json value
    char type = pTagVal->type;
    if (type == TSDB_DATA_TYPE_NULL) {
      cJSON* value = cJSON_CreateNull();
      if (value == NULL) {
        goto end;
      }
      cJSON_AddItemToObject(json, tagJsonKey, value);
    } else if (type == TSDB_DATA_TYPE_NCHAR) {
      cJSON* value = NULL;
      if (pTagVal->nData > 0) {
        char*   tagJsonValue = taosMemoryCalloc(pTagVal->nData, 1);
        int32_t length = taosUcs4ToMbs((TdUcs4*)pTagVal->pData, pTagVal->nData, tagJsonValue);
        if (length < 0) {
          qError("charset:%s to %s. val:%s convert json value failed.", DEFAULT_UNICODE_ENCODEC, tsCharset,
dengyihao's avatar
dengyihao 已提交
384
                 pTagVal->pData);
D
dapan1121 已提交
385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420
          taosMemoryFree(tagJsonValue);
          goto end;
        }
        value = cJSON_CreateString(tagJsonValue);
        taosMemoryFree(tagJsonValue);
        if (value == NULL) {
          goto end;
        }
      } else if (pTagVal->nData == 0) {
        value = cJSON_CreateString("");
      } else {
        ASSERT(0);
      }

      cJSON_AddItemToObject(json, tagJsonKey, value);
    } else if (type == TSDB_DATA_TYPE_DOUBLE) {
      double jsonVd = *(double*)(&pTagVal->i64);
      cJSON* value = cJSON_CreateNumber(jsonVd);
      if (value == NULL) {
        goto end;
      }
      cJSON_AddItemToObject(json, tagJsonKey, value);
    } else if (type == TSDB_DATA_TYPE_BOOL) {
      char   jsonVd = *(char*)(&pTagVal->i64);
      cJSON* value = cJSON_CreateBool(jsonVd);
      if (value == NULL) {
        goto end;
      }
      cJSON_AddItemToObject(json, tagJsonKey, value);
    } else {
      ASSERT(0);
    }
  }
  string = cJSON_PrintUnformatted(json);
end:
  cJSON_Delete(json);
wmmhello's avatar
wmmhello 已提交
421
  taosArrayDestroy(pTagVals);
dengyihao's avatar
dengyihao 已提交
422
  if (string == NULL) {
wmmhello's avatar
wmmhello 已提交
423 424
    string = strdup(TSDB_DATA_NULL_STR_L);
  }
D
dapan1121 已提交
425 426 427
  return string;
}

D
dapan1121 已提交
428 429 430 431 432 433
int32_t cloneTableMeta(STableMeta* pSrc, STableMeta** pDst) {
  if (NULL == pSrc) {
    *pDst = NULL;
    return TSDB_CODE_SUCCESS;
  }

X
Xiaoyu Wang 已提交
434 435
  int32_t numOfField = pSrc->tableInfo.numOfColumns + pSrc->tableInfo.numOfTags;
  if (numOfField > TSDB_MAX_COL_TAG_NUM || numOfField < TSDB_MIN_COLUMNS) {
D
dapan1121 已提交
436 437 438 439 440
    *pDst = NULL;
    qError("too many column and tag num:%d,%d", pSrc->tableInfo.numOfColumns, pSrc->tableInfo.numOfTags);
    return TSDB_CODE_INVALID_PARA;
  }

X
Xiaoyu Wang 已提交
441
  int32_t metaSize = sizeof(STableMeta) + numOfField * sizeof(SSchema);
D
dapan1121 已提交
442 443 444 445 446 447 448 449 450 451 452 453 454
  *pDst = taosMemoryMalloc(metaSize);
  if (NULL == *pDst) {
    return TSDB_CODE_TSC_OUT_OF_MEMORY;
  }
  memcpy(*pDst, pSrc, metaSize);
  return TSDB_CODE_SUCCESS;
}

int32_t cloneDbVgInfo(SDBVgInfo* pSrc, SDBVgInfo** pDst) {
  if (NULL == pSrc) {
    *pDst = NULL;
    return TSDB_CODE_SUCCESS;
  }
dengyihao's avatar
dengyihao 已提交
455

D
dapan1121 已提交
456 457 458 459 460 461
  *pDst = taosMemoryMalloc(sizeof(*pSrc));
  if (NULL == *pDst) {
    return TSDB_CODE_TSC_OUT_OF_MEMORY;
  }
  memcpy(*pDst, pSrc, sizeof(*pSrc));
  if (pSrc->vgHash) {
dengyihao's avatar
dengyihao 已提交
462 463
    (*pDst)->vgHash = taosHashInit(taosHashGetSize(pSrc->vgHash), taosGetDefaultHashFunction(TSDB_DATA_TYPE_INT), true,
                                   HASH_ENTRY_LOCK);
D
dapan1121 已提交
464
    if (NULL == (*pDst)->vgHash) {
D
dapan1121 已提交
465
      taosMemoryFreeClear(*pDst);
D
dapan1121 已提交
466 467 468 469
      return TSDB_CODE_TSC_OUT_OF_MEMORY;
    }

    SVgroupInfo* vgInfo = NULL;
dengyihao's avatar
dengyihao 已提交
470
    void*        pIter = taosHashIterate(pSrc->vgHash, NULL);
D
dapan1121 已提交
471 472 473
    while (pIter) {
      vgInfo = pIter;
      int32_t* vgId = taosHashGetKey(pIter, NULL);
dengyihao's avatar
dengyihao 已提交
474

D
dapan1121 已提交
475 476
      if (0 != taosHashPut((*pDst)->vgHash, vgId, sizeof(*vgId), vgInfo, sizeof(*vgInfo))) {
        qError("taosHashPut failed, vgId:%d", vgInfo->vgId);
dengyihao's avatar
dengyihao 已提交
477
        taosHashCancelIterate(pSrc->vgHash, pIter);
D
dapan1121 已提交
478 479
        taosHashCleanup((*pDst)->vgHash);
        taosMemoryFreeClear(*pDst);
D
dapan1121 已提交
480
        return TSDB_CODE_OUT_OF_MEMORY;
D
dapan1121 已提交
481
      }
dengyihao's avatar
dengyihao 已提交
482

D
dapan1121 已提交
483 484 485
      pIter = taosHashIterate(pSrc->vgHash, pIter);
    }
  }
dengyihao's avatar
dengyihao 已提交
486

D
dapan1121 已提交
487 488
  return TSDB_CODE_SUCCESS;
}