title: Create a "temporary" table in spark-SQL, not spark-scala?
body: <p>I have loaded a table from an input file.</p>
  
  <pre><code>CREATE TABLE MyTable (
      ID INT,
      VALUE FLOAT,
      RATE  INT
  ...
  
  LOAD DATA LOCAL INPATH 'MYPATH' INTO TABLE MyTable;
  </code></pre>
  
  <p>Now I'd like to create a new based on this one</p>
  
  <pre><code>DerivedTable = 
      SELECT ID, VALUE*RATE AS Total
      FROM MyTable
      WHERE VALUE IS NOT NULL;
  </code></pre>
  
  <p>Then I'm going to use this table as a source for other tables and for outputs.</p>
  
  <p>What is a correct Sql (or Hive) way to create this "temporary" table? This should work in <code>spark-sql</code>?</p>
  
  <p>PS: I know how to do that in spark-shell. But that is not what I'm looking for.</p>