queryUtil.c 12.7 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

D
dapan1121 已提交
137
  taosScheduleTask(&pTaskQueue, &schedMsg);
L
Liu Jicong 已提交
138
  return 0;
H
Haojun Liao 已提交
139
}
140

D
dapan1121 已提交
141 142 143 144 145 146 147 148 149 150
void destroySendMsgInfo(SMsgSendInfo* pMsgBody) {
  assert(pMsgBody != NULL);
  taosMemoryFreeClear(pMsgBody->target.dbFName);
  taosMemoryFreeClear(pMsgBody->msgInfo.pData);
  if (pMsgBody->paramFreeFp) {
    (*pMsgBody->paramFreeFp)(pMsgBody->param);
  }
  taosMemoryFreeClear(pMsgBody);
}

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

  memcpy(pMsg, pInfo->msgInfo.pData, pInfo->msgInfo.len);
dengyihao's avatar
dengyihao 已提交
162 163 164 165 166 167 168 169 170
  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 已提交
171
  TRACE_SET_ROOTID(&rpcMsg.info.traceId, pInfo->requestId);
D
dapan1121 已提交
172 173 174 175 176
  int code = rpcSendRequestWithCtx(pTransporter, epSet, &rpcMsg, pTransporterId, rpcCtx);
  if (code) {
    destroySendMsgInfo(pInfo);
  }
  return code;
L
Liu Jicong 已提交
177
}
D
dapan1121 已提交
178

D
dapan1121 已提交
179
int32_t asyncSendMsgToServer(void* pTransporter, SEpSet* epSet, int64_t* pTransporterId, SMsgSendInfo* pInfo) {
180
  return asyncSendMsgToServerExt(pTransporter, epSet, pTransporterId, pInfo, false, NULL);
D
dapan1121 已提交
181 182
}

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

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

206
SSchema createSchema(int8_t type, int32_t bytes, col_id_t colId, const char* name) {
D
dapan1121 已提交
207
  SSchema s = {0};
dengyihao's avatar
dengyihao 已提交
208
  s.type = type;
D
dapan1121 已提交
209 210 211 212 213 214
  s.bytes = bytes;
  s.colId = colId;

  tstrncpy(s.name, name, tListLen(s.name));
  return s;
}
D
dapan1121 已提交
215

216 217 218 219 220
void freeSTableMetaRspPointer(void *p) {
  tFreeSTableMetaRsp(*(void**)p);
  taosMemoryFreeClear(*(void**)p);
}

D
dapan1121 已提交
221
void destroyQueryExecRes(SExecResult* pRes) {
D
dapan1121 已提交
222 223 224 225 226
  if (NULL == pRes || NULL == pRes->res) {
    return;
  }

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

dengyihao's avatar
dengyihao 已提交
253
int32_t dataConverToStr(char* str, int type, void* buf, int32_t bufSize, int32_t* len) {
D
dapan1121 已提交
254 255 256 257 258 259 260 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
  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 已提交
292
        //        tscError("invalid buf size");
D
dapan1121 已提交
293 294 295 296 297 298 299 300
        return TSDB_CODE_TSC_INVALID_VALUE;
      }

      *str = '"';
      memcpy(str + 1, buf, bufSize);
      *(str + bufSize + 1) = '"';
      n = bufSize + 2;
      break;
wmmhello's avatar
wmmhello 已提交
301 302 303 304 305
    case TSDB_DATA_TYPE_NCHAR:
      if (bufSize < 0) {
        //        tscError("invalid buf size");
        return TSDB_CODE_TSC_INVALID_VALUE;
      }
D
dapan1121 已提交
306

wmmhello's avatar
wmmhello 已提交
307
      *str = '"';
dengyihao's avatar
dengyihao 已提交
308
      int32_t length = taosUcs4ToMbs((TdUcs4*)buf, bufSize, str + 1);
wmmhello's avatar
wmmhello 已提交
309 310 311 312 313 314
      if (length <= 0) {
        return TSDB_CODE_TSC_INVALID_VALUE;
      }
      *(str + length + 1) = '"';
      n = length + 2;
      break;
D
dapan1121 已提交
315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331
    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 已提交
332
      //      tscError("unsupported type:%d", type);
D
dapan1121 已提交
333 334 335
      return TSDB_CODE_TSC_INVALID_VALUE;
  }

dengyihao's avatar
dengyihao 已提交
336
  if (len) *len = n;
D
dapan1121 已提交
337 338 339 340

  return TSDB_CODE_SUCCESS;
}

D
dapan1121 已提交
341
char* parseTagDatatoJson(void* p) {
dengyihao's avatar
dengyihao 已提交
342
  char*   string = NULL;
D
dapan1121 已提交
343
  SArray* pTagVals = NULL;
dengyihao's avatar
dengyihao 已提交
344
  cJSON*  json = NULL;
D
dapan1121 已提交
345 346 347 348 349
  if (tTagToValArray((const STag*)p, &pTagVals) != 0) {
    goto end;
  }

  int16_t nCols = taosArrayGetSize(pTagVals);
wmmhello's avatar
wmmhello 已提交
350 351 352
  if (nCols == 0) {
    goto end;
  }
dengyihao's avatar
dengyihao 已提交
353
  char tagJsonKey[256] = {0};
wmmhello's avatar
wmmhello 已提交
354 355 356 357
  json = cJSON_CreateObject();
  if (json == NULL) {
    goto end;
  }
D
dapan1121 已提交
358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377
  for (int j = 0; j < nCols; ++j) {
    STagVal* pTagVal = (STagVal*)taosArrayGet(pTagVals, j);
    // json key  encode by binary
    memset(tagJsonKey, 0, sizeof(tagJsonKey));
    memcpy(tagJsonKey, pTagVal->pKey, strlen(pTagVal->pKey));
    // 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 已提交
378
                 pTagVal->pData);
D
dapan1121 已提交
379 380 381 382 383 384 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
          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 已提交
415
  taosArrayDestroy(pTagVals);
dengyihao's avatar
dengyihao 已提交
416
  if (string == NULL) {
wmmhello's avatar
wmmhello 已提交
417 418
    string = strdup(TSDB_DATA_NULL_STR_L);
  }
D
dapan1121 已提交
419 420 421
  return string;
}

D
dapan1121 已提交
422 423 424 425 426 427
int32_t cloneTableMeta(STableMeta* pSrc, STableMeta** pDst) {
  if (NULL == pSrc) {
    *pDst = NULL;
    return TSDB_CODE_SUCCESS;
  }

428
  int32_t metaSize = sizeof(STableMeta) + (pSrc->tableInfo.numOfColumns + pSrc->tableInfo.numOfTags) * sizeof(SSchema);
D
dapan1121 已提交
429 430 431 432 433 434 435 436 437 438 439 440 441
  *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 已提交
442

D
dapan1121 已提交
443 444 445 446 447 448
  *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 已提交
449 450
    (*pDst)->vgHash = taosHashInit(taosHashGetSize(pSrc->vgHash), taosGetDefaultHashFunction(TSDB_DATA_TYPE_INT), true,
                                   HASH_ENTRY_LOCK);
D
dapan1121 已提交
451 452 453 454 455
    if (NULL == (*pDst)->vgHash) {
      return TSDB_CODE_TSC_OUT_OF_MEMORY;
    }

    SVgroupInfo* vgInfo = NULL;
dengyihao's avatar
dengyihao 已提交
456
    void*        pIter = taosHashIterate(pSrc->vgHash, NULL);
D
dapan1121 已提交
457 458 459
    while (pIter) {
      vgInfo = pIter;
      int32_t* vgId = taosHashGetKey(pIter, NULL);
dengyihao's avatar
dengyihao 已提交
460

D
dapan1121 已提交
461 462
      if (0 != taosHashPut((*pDst)->vgHash, vgId, sizeof(*vgId), vgInfo, sizeof(*vgInfo))) {
        qError("taosHashPut failed, vgId:%d", vgInfo->vgId);
dengyihao's avatar
dengyihao 已提交
463
        taosHashCancelIterate(pSrc->vgHash, pIter);
D
dapan1121 已提交
464 465
        taosHashCleanup((*pDst)->vgHash);
        taosMemoryFreeClear(*pDst);
D
dapan1121 已提交
466
        return TSDB_CODE_OUT_OF_MEMORY;
D
dapan1121 已提交
467
      }
dengyihao's avatar
dengyihao 已提交
468

D
dapan1121 已提交
469 470 471
      pIter = taosHashIterate(pSrc->vgHash, pIter);
    }
  }
dengyihao's avatar
dengyihao 已提交
472

D
dapan1121 已提交
473 474
  return TSDB_CODE_SUCCESS;
}
D
dapan1121 已提交
475 476