OmniSciDB  cde582ebc3
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
UtilityTableFunctions.cpp
Go to the documentation of this file.
1 /*
2  * Copyright 2022 HEAVY.AI, Inc.
3  *
4  * Licensed under the Apache License, Version 2.0 (the "License");
5  * you may not use this file except in compliance with the License.
6  * You may obtain a copy of the License at
7  *
8  * http://www.apache.org/licenses/LICENSE-2.0
9  *
10  * Unless required by applicable law or agreed to in writing, software
11  * distributed under the License is distributed on an "AS IS" BASIS,
12  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13  * See the License for the specific language governing permissions and
14  * limitations under the License.
15  */
16 
17 #ifndef __CUDACC__
18 
19 #include <string>
20 
21 #ifdef HAVE_TBB
22 #include <tbb/parallel_for.h>
23 #include <tbb/task_arena.h>
24 #endif
25 
26 #include "Shared/ThreadInfo.h"
27 #include "UtilityTableFunctions.h"
28 
30 #ifdef _WIN32
31 #pragma comment(linker "/INCLUDE:generate_series_parallel")
32 #else
33 __attribute__((__used__))
34 #endif
35 int32_t generate_series_parallel(const int64_t start,
36  const int64_t stop,
37  const int64_t step,
38  Column<int64_t>& series_output) {
39  const int64_t num_rows = ((stop - start) / step) + 1;
40 
41  tbb::parallel_for(tbb::blocked_range<int64_t>(0, num_rows),
42  [&](const tbb::blocked_range<int64_t>& r) {
43  const int64_t start_out_idx = r.begin();
44  const int64_t end_out_idx = r.end();
45  for (int64_t out_idx = start_out_idx; out_idx != end_out_idx;
46  ++out_idx) {
47  series_output[out_idx] = start + out_idx * step;
48  }
49  });
50  return num_rows;
51 }
52 
54 #ifdef _WIN32
55 #pragma comment(linker "/INCLUDE:generate_series__cpu_1")
56 #else
57 __attribute__((__used__))
58 #endif
60  const int64_t start,
61  const int64_t stop,
62  const int64_t step,
63  Column<int64_t>& series_output) {
64  const int64_t MAX_ROWS{1L << 30};
65  const int64_t PARALLEL_THRESHOLD{10000L};
66  const int64_t num_rows = ((stop - start) / step) + 1;
67  if (num_rows <= 0) {
68  mgr.set_output_row_size(0);
69  return 0;
70  }
71  mgr.set_output_row_size(num_rows);
72 
73  if (num_rows > MAX_ROWS) {
74  return mgr.ERROR_MESSAGE(
75  "Invocation of generate_series would result in " + std::to_string(num_rows) +
76  " rows, which exceeds the max limit of " + std::to_string(MAX_ROWS) + " rows.");
77  }
78 
79 #ifdef HAVE_TBB
80  if (num_rows > PARALLEL_THRESHOLD) {
81  return generate_series_parallel(start, stop, step, series_output);
82  }
83 #endif
84 
85  for (int64_t out_idx = 0; out_idx != num_rows; ++out_idx) {
86  series_output[out_idx] = start + out_idx * step;
87  }
88  return num_rows;
89 }
90 
92 #ifdef _WIN32
93 #pragma comment(linker "/INCLUDE:generate_series__cpu_2")
94 #else
95 __attribute__((__used__))
96 #endif
98  const int64_t start,
99  const int64_t stop,
100  Column<int64_t>& series_output) {
101  return generate_series__cpu_1(mgr, start, stop, 1, series_output);
102 }
103 
104 #include <chrono>
105 #include <random>
106 #include <thread>
107 
108 HOST std::string gen_random_str(std::mt19937& generator, const int64_t str_len) {
109  constexpr char alphanum_lookup_table[] =
110  "0123456789"
111  "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
112  "abcdefghijklmnopqrstuvwxyz";
113  constexpr size_t char_mod = sizeof(alphanum_lookup_table) - 1;
114  std::uniform_int_distribution<int32_t> rand_distribution(0, char_mod);
115 
116  std::string tmp_s;
117  tmp_s.reserve(str_len);
118  for (int i = 0; i < str_len; ++i) {
119  tmp_s += alphanum_lookup_table[rand_distribution(generator)];
120  }
121  return tmp_s;
122 }
123 
125 #ifdef _WIN32
126 #pragma comment(linker "/INCLUDE:generate_random_strings__cpu_")
127 #else
128 __attribute__((__used__))
129 #endif
131  const int64_t num_strings,
132  const int64_t string_length,
133  Column<int64_t>& output_id,
134  Column<TextEncodingDict>& output_strings) {
135  auto timer = DEBUG_TIMER(__func__);
136  // Check for out-of-range errors for the input parameters
137  // in the function instead of with require due to issue encountered
138  // with require over multiple variables
139  constexpr int64_t max_strings{10000000L};
140  constexpr int64_t max_str_len{10000L};
141  if (num_strings > max_strings) {
142  return mgr.ERROR_MESSAGE(
143  "generate_random_strings: num_strings must be between 0 and 10,000,000.");
144  }
145  if (string_length > max_str_len) {
146  return mgr.ERROR_MESSAGE(
147  "generate_random_strings: string_length must be between 1 and 10,000.");
148  }
149  if (num_strings == 0L) {
150  // Bail early as there is no work to be done
151  return 0;
152  }
153 
154  mgr.set_output_row_size(num_strings);
155  constexpr int64_t target_strings_per_thread{5000};
156  const ThreadInfo thread_info(
157  std::thread::hardware_concurrency(), num_strings, target_strings_per_thread);
158  std::vector<std::mt19937> per_thread_rand_generators;
159  per_thread_rand_generators.reserve(thread_info.num_threads);
160  for (int64_t thread_idx = 0; thread_idx < thread_info.num_threads; ++thread_idx) {
161  const uint64_t seed = std::chrono::duration_cast<std::chrono::nanoseconds>(
162  std::chrono::system_clock::now().time_since_epoch())
163  .count() +
164  thread_idx * 971;
165  per_thread_rand_generators.emplace_back(seed);
166  }
167  std::vector<std::string> rand_strings(num_strings);
168  tbb::task_arena limited_arena(thread_info.num_threads);
169  limited_arena.execute([&] {
170  CHECK_LE(tbb::this_task_arena::max_concurrency(), thread_info.num_threads);
172  tbb::blocked_range<int64_t>(0, num_strings, thread_info.num_elems_per_thread),
173  [&](const tbb::blocked_range<int64_t>& r) {
174  const int64_t tbb_thread_idx = tbb::this_task_arena::current_thread_index();
175  const int64_t start_out_idx = r.begin();
176  const int64_t end_out_idx = r.end();
177  for (int64_t out_idx = start_out_idx; out_idx != end_out_idx; ++out_idx) {
178  rand_strings[out_idx] =
179  gen_random_str(per_thread_rand_generators[tbb_thread_idx], string_length);
180  }
181  },
182  tbb::simple_partitioner());
183  });
184  const std::vector<int32_t> rand_string_ids =
185  output_strings.string_dict_proxy_->getOrAddTransientBulk(rand_strings);
186  for (int64_t row_idx = 0; row_idx < num_strings; row_idx++) {
187  output_id[row_idx] = row_idx;
188  output_strings[row_idx] = rand_string_ids[row_idx];
189  }
190  return num_strings;
191 }
192 
193 #endif //__CUDACC__
void set_output_row_size(int64_t num_rows)
Definition: heavydbTypes.h:679
int64_t num_elems_per_thread
Definition: ThreadInfo.h:23
EXTENSION_NOINLINE_HOST int32_t generate_random_strings__cpu_(TableFunctionManager &mgr, const int64_t num_strings, const int64_t string_length, Column< int64_t > &output_id, Column< TextEncodingDict > &output_strings)
std::string to_string(char const *&&v)
#define HOST
EXTENSION_NOINLINE_HOST int32_t generate_series_parallel(const int64_t start, const int64_t stop, const int64_t step, Column< int64_t > &series_output)
FORCE_INLINE T __attribute__((__may_alias__))*may_alias_ptr(T *ptr)
Definition: TypePunning.h:32
int64_t num_threads
Definition: ThreadInfo.h:22
#define EXTENSION_NOINLINE_HOST
Definition: heavydbTypes.h:44
#define CHECK_LE(x, y)
Definition: Logger.h:233
void parallel_for(const blocked_range< Int > &range, const Body &body, const Partitioner &p=Partitioner())
EXTENSION_NOINLINE_HOST int32_t generate_series__cpu_2(TableFunctionManager &mgr, const int64_t start, const int64_t stop, Column< int64_t > &series_output)
#define DEBUG_TIMER(name)
Definition: Logger.h:371
HOST std::string gen_random_str(std::mt19937 &generator, const int64_t str_len)
EXTENSION_NOINLINE_HOST int32_t generate_series__cpu_1(TableFunctionManager &mgr, const int64_t start, const int64_t stop, const int64_t step, Column< int64_t > &series_output)