queryUtil.c 11.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 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 269
  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:
    case TSDB_DATA_TYPE_NCHAR:
      if (bufSize < 0) {
dengyihao's avatar
dengyihao 已提交
270
        //        tscError("invalid buf size");
D
dapan1121 已提交
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
        return TSDB_CODE_TSC_INVALID_VALUE;
      }

      *str = '"';
      memcpy(str + 1, buf, bufSize);
      *(str + bufSize + 1) = '"';
      n = bufSize + 2;
      break;

    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 已提交
297
      //      tscError("unsupported type:%d", type);
D
dapan1121 已提交
298 299 300 301 302 303 304 305
      return TSDB_CODE_TSC_INVALID_VALUE;
  }

  *len = n;

  return TSDB_CODE_SUCCESS;
}

D
dapan1121 已提交
306 307 308
char* parseTagDatatoJson(void* p) {
  char*  string = NULL;
  SArray* pTagVals = NULL;
wmmhello's avatar
wmmhello 已提交
309
  cJSON* json = NULL;
D
dapan1121 已提交
310 311 312 313 314
  if (tTagToValArray((const STag*)p, &pTagVals) != 0) {
    goto end;
  }

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

D
dapan1121 已提交
387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406
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 已提交
407

D
dapan1121 已提交
408 409 410 411 412 413
  *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 已提交
414 415
    (*pDst)->vgHash = taosHashInit(taosHashGetSize(pSrc->vgHash), taosGetDefaultHashFunction(TSDB_DATA_TYPE_INT), true,
                                   HASH_ENTRY_LOCK);
D
dapan1121 已提交
416 417 418 419 420
    if (NULL == (*pDst)->vgHash) {
      return TSDB_CODE_TSC_OUT_OF_MEMORY;
    }

    SVgroupInfo* vgInfo = NULL;
dengyihao's avatar
dengyihao 已提交
421
    void*        pIter = taosHashIterate(pSrc->vgHash, NULL);
D
dapan1121 已提交
422 423 424
    while (pIter) {
      vgInfo = pIter;
      int32_t* vgId = taosHashGetKey(pIter, NULL);
dengyihao's avatar
dengyihao 已提交
425

D
dapan1121 已提交
426 427
      if (0 != taosHashPut((*pDst)->vgHash, vgId, sizeof(*vgId), vgInfo, sizeof(*vgInfo))) {
        qError("taosHashPut failed, vgId:%d", vgInfo->vgId);
dengyihao's avatar
dengyihao 已提交
428
        taosHashCancelIterate(pSrc->vgHash, pIter);
D
dapan1121 已提交
429 430
        taosHashCleanup((*pDst)->vgHash);
        taosMemoryFreeClear(*pDst);
D
dapan1121 已提交
431
        return TSDB_CODE_OUT_OF_MEMORY;
D
dapan1121 已提交
432
      }
dengyihao's avatar
dengyihao 已提交
433

D
dapan1121 已提交
434 435 436
      pIter = taosHashIterate(pSrc->vgHash, pIter);
    }
  }
dengyihao's avatar
dengyihao 已提交
437

D
dapan1121 已提交
438 439
  return TSDB_CODE_SUCCESS;
}