title: how can I create a table in Vertica with receiving time?
body: <p>I get weather telemetries from Kafka and insert it to Vertica.
  I want to add to the vertica table a <code>'receive_time'</code> type <code>timestamp</code> column and <code>'receive_date'</code> type <code>date</code> column that indicate the exact time a telemetry was been inserted to the table.</p>
  <p>this is my creation statement for example:</p>
  <pre><code>CREATE TABLE my_scheme.weather
  (
      location_id int NOT NULL,
      humidity float,
      current_temp float,
      wind_speed float,
      wind_direction varchar(100),
      feels_like float,
      latitude float,
      longitude float,
      current_condition varchar(100)
  );
  </code></pre>
  <p>how to add <code>'receive_time'</code> and <code>'receive_date'</code> columns that get the time from the Vertica? it is even possible?</p>