queryUtil.c 12.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 99 100 101
}

static void* pTaskQueue = NULL;

int32_t initTaskQueue() {
S
Shengliang Guan 已提交
102
  int32_t queueSize = tsMaxShellConns * 2;
S
Shengliang Guan 已提交
103
  pTaskQueue = taosInitScheduler(queueSize, tsNumOfTaskQueueThreads, "tsc");
H
Haojun Liao 已提交
104 105 106 107 108
  if (NULL == pTaskQueue) {
    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 114
}

int32_t cleanupTaskQueue() {
  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 137

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

141 142
int32_t asyncSendMsgToServerExt(void* pTransporter, SEpSet* epSet, int64_t* pTransporterId, const SMsgSendInfo* pInfo,
                                bool persistHandle, void* rpcCtx) {
L
Liu Jicong 已提交
143
  char* pMsg = rpcMallocCont(pInfo->msgInfo.len);
144
  if (NULL == pMsg) {
L
Liu Jicong 已提交
145
    qError("0x%" PRIx64 " msg:%s malloc failed", pInfo->requestId, TMSG_INFO(pInfo->msgType));
146
    terrno = TSDB_CODE_TSC_OUT_OF_MEMORY;
147
    return terrno;
148 149 150
  }

  memcpy(pMsg, pInfo->msgInfo.pData, pInfo->msgInfo.len);
dengyihao's avatar
dengyihao 已提交
151 152 153 154 155 156 157 158 159
  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
  };
160
  assert(pInfo->fp != NULL);
dengyihao's avatar
dengyihao 已提交
161
  TRACE_SET_ROOTID(&rpcMsg.info.traceId, pInfo->requestId);
162
  rpcSendRequestWithCtx(pTransporter, epSet, &rpcMsg, pTransporterId, rpcCtx);
163
  return TSDB_CODE_SUCCESS;
L
Liu Jicong 已提交
164
}
D
dapan1121 已提交
165

166 167
int32_t asyncSendMsgToServer(void* pTransporter, SEpSet* epSet, int64_t* pTransporterId, const SMsgSendInfo* pInfo) {
  return asyncSendMsgToServerExt(pTransporter, epSet, pTransporterId, pInfo, false, NULL);
D
dapan1121 已提交
168 169
}

dengyihao's avatar
dengyihao 已提交
170
char* jobTaskStatusStr(int32_t status) {
D
dapan1121 已提交
171 172 173
  switch (status) {
    case JOB_TASK_STATUS_NULL:
      return "NULL";
D
dapan1121 已提交
174 175 176
    case JOB_TASK_STATUS_INIT:
      return "INIT";
    case JOB_TASK_STATUS_EXEC:
D
dapan1121 已提交
177
      return "EXECUTING";
D
dapan1121 已提交
178
    case JOB_TASK_STATUS_PART_SUCC:
D
dapan1121 已提交
179
      return "PARTIAL_SUCCEED";
D
dapan1121 已提交
180
    case JOB_TASK_STATUS_SUCC:
D
dapan1121 已提交
181
      return "SUCCEED";
D
dapan1121 已提交
182
    case JOB_TASK_STATUS_FAIL:
D
dapan1121 已提交
183
      return "FAILED";
D
dapan1121 已提交
184
    case JOB_TASK_STATUS_DROP:
D
dapan1121 已提交
185 186 187 188 189 190 191
      return "DROPPING";
    default:
      break;
  }

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

193
SSchema createSchema(int8_t type, int32_t bytes, col_id_t colId, const char* name) {
D
dapan1121 已提交
194
  SSchema s = {0};
dengyihao's avatar
dengyihao 已提交
195
  s.type = type;
D
dapan1121 已提交
196 197 198 199 200 201
  s.bytes = bytes;
  s.colId = colId;

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

D
dapan1121 已提交
203
void destroyQueryExecRes(SExecResult* pRes) {
D
dapan1121 已提交
204 205 206 207 208 209 210
  if (NULL == pRes || NULL == pRes->res) {
    return;
  }

  switch (pRes->msgType) {
    case TDMT_VND_ALTER_TABLE:
    case TDMT_MND_ALTER_STB: {
dengyihao's avatar
dengyihao 已提交
211
      tFreeSTableMetaRsp((STableMetaRsp*)pRes->res);
D
dapan1121 已提交
212 213 214 215 216 217
      taosMemoryFreeClear(pRes->res);
      break;
    }
    case TDMT_VND_SUBMIT: {
      tFreeSSubmitRsp((SSubmitRsp*)pRes->res);
      break;
dengyihao's avatar
dengyihao 已提交
218
    }
D
dapan1121 已提交
219 220
    case TDMT_SCH_QUERY: 
    case TDMT_SCH_MERGE_QUERY: {
D
dapan1121 已提交
221 222 223 224 225 226 227
      taosArrayDestroy((SArray*)pRes->res);
      break;
    }
    default:
      qError("invalid exec result for request type %d", pRes->msgType);
  }
}
dengyihao's avatar
dengyihao 已提交
228
// clang-format on
D
dapan1121 已提交
229

dengyihao's avatar
dengyihao 已提交
230
int32_t dataConverToStr(char* str, int type, void* buf, int32_t bufSize, int32_t* len) {
D
dapan1121 已提交
231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268
  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 已提交
269
        //        tscError("invalid buf size");
D
dapan1121 已提交
270 271 272 273 274 275 276 277
        return TSDB_CODE_TSC_INVALID_VALUE;
      }

      *str = '"';
      memcpy(str + 1, buf, bufSize);
      *(str + bufSize + 1) = '"';
      n = bufSize + 2;
      break;
wmmhello's avatar
wmmhello 已提交
278 279 280 281 282
    case TSDB_DATA_TYPE_NCHAR:
      if (bufSize < 0) {
        //        tscError("invalid buf size");
        return TSDB_CODE_TSC_INVALID_VALUE;
      }
D
dapan1121 已提交
283

wmmhello's avatar
wmmhello 已提交
284 285 286 287 288 289 290 291
      *str = '"';
      int32_t length = taosUcs4ToMbs((TdUcs4 *)buf, bufSize, str + 1);
      if (length <= 0) {
        return TSDB_CODE_TSC_INVALID_VALUE;
      }
      *(str + length + 1) = '"';
      n = length + 2;
      break;
D
dapan1121 已提交
292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308
    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 已提交
309
      //      tscError("unsupported type:%d", type);
D
dapan1121 已提交
310 311 312
      return TSDB_CODE_TSC_INVALID_VALUE;
  }

wmmhello's avatar
wmmhello 已提交
313
  if(len) *len = n;
D
dapan1121 已提交
314 315 316 317

  return TSDB_CODE_SUCCESS;
}

D
dapan1121 已提交
318 319 320
char* parseTagDatatoJson(void* p) {
  char*  string = NULL;
  SArray* pTagVals = NULL;
wmmhello's avatar
wmmhello 已提交
321
  cJSON* json = NULL;
D
dapan1121 已提交
322 323 324 325 326
  if (tTagToValArray((const STag*)p, &pTagVals) != 0) {
    goto end;
  }

  int16_t nCols = taosArrayGetSize(pTagVals);
wmmhello's avatar
wmmhello 已提交
327 328 329
  if (nCols == 0) {
    goto end;
  }
D
dapan1121 已提交
330
  char    tagJsonKey[256] = {0};
wmmhello's avatar
wmmhello 已提交
331 332 333 334
  json = cJSON_CreateObject();
  if (json == NULL) {
    goto end;
  }
D
dapan1121 已提交
335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354
  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 已提交
355
                 pTagVal->pData);
D
dapan1121 已提交
356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391
          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 已提交
392 393 394 395
  taosArrayDestroy(pTagVals);
  if(string == NULL){
    string = strdup(TSDB_DATA_NULL_STR_L);
  }
D
dapan1121 已提交
396 397 398
  return string;
}

D
dapan1121 已提交
399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418
int32_t cloneTableMeta(STableMeta* pSrc, STableMeta** pDst) {
  if (NULL == pSrc) {
    *pDst = NULL;
    return TSDB_CODE_SUCCESS;
  }

  int32_t metaSize = (pSrc->tableInfo.numOfColumns + pSrc->tableInfo.numOfTags) * sizeof(SSchema);
  *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 已提交
419

D
dapan1121 已提交
420 421 422 423 424 425
  *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 已提交
426 427
    (*pDst)->vgHash = taosHashInit(taosHashGetSize(pSrc->vgHash), taosGetDefaultHashFunction(TSDB_DATA_TYPE_INT), true,
                                   HASH_ENTRY_LOCK);
D
dapan1121 已提交
428 429 430 431 432
    if (NULL == (*pDst)->vgHash) {
      return TSDB_CODE_TSC_OUT_OF_MEMORY;
    }

    SVgroupInfo* vgInfo = NULL;
dengyihao's avatar
dengyihao 已提交
433
    void*        pIter = taosHashIterate(pSrc->vgHash, NULL);
D
dapan1121 已提交
434 435 436
    while (pIter) {
      vgInfo = pIter;
      int32_t* vgId = taosHashGetKey(pIter, NULL);
dengyihao's avatar
dengyihao 已提交
437

D
dapan1121 已提交
438 439
      if (0 != taosHashPut((*pDst)->vgHash, vgId, sizeof(*vgId), vgInfo, sizeof(*vgInfo))) {
        qError("taosHashPut failed, vgId:%d", vgInfo->vgId);
dengyihao's avatar
dengyihao 已提交
440
        taosHashCancelIterate(pSrc->vgHash, pIter);
D
dapan1121 已提交
441 442
        taosHashCleanup((*pDst)->vgHash);
        taosMemoryFreeClear(*pDst);
D
dapan1121 已提交
443
        return TSDB_CODE_OUT_OF_MEMORY;
D
dapan1121 已提交
444
      }
dengyihao's avatar
dengyihao 已提交
445

D
dapan1121 已提交
446 447 448
      pIter = taosHashIterate(pSrc->vgHash, pIter);
    }
  }
dengyihao's avatar
dengyihao 已提交
449

D
dapan1121 已提交
450 451
  return TSDB_CODE_SUCCESS;
}