title: how to load data from a .dat file into a table using cql
body: <p>I try to load data from a .dat file into my table using cql. I can only find the commend to read from csv file in documentation, so tried that kind of commend but all get error:</p>
  
  <pre><code>copy users (uid, gender, age, occu, zip) from ('/cassandra-input/users.dat') with delimiter = ':';
  Improper copy command.
  
  copy users (uid, gender, age, occu, zip) from ('/cassandra-input/users.dat' | stdin) with delimiter = ':';
      Invalid syntax at line 1, char 77
        copy users (uid, gender, age, occu, zip) from ('/cassandra-input/users.dat' | stdin) with delimiter = ':';
  
    copy users from '/cassandra-input/users.dat' with delimiter = ':';
  Not in any keyspace.  
  </code></pre>
  
  <p>so is there any one who can help me to figure out how to do this loading job.</p>