daily pastebin goal
47%
SHARE
TWEET

Untitled

a guest Sep 26th, 2016 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> describe orders;
  2. +-------------------+-------------+------+-----+---------+-------+
  3. | Field             | Type        | Null | Key | Default | Extra |
  4. +-------------------+-------------+------+-----+---------+-------+
  5. | order_id          | int(11)     | YES  |     | NULL    |       |
  6. | order_date        | varchar(30) | YES  |     | NULL    |       |
  7. | order_customer_id | int(11)     | YES  |     | NULL    |       |
  8. | order_items       | varchar(30) | YES  |     | NULL    |       |
  9. +-------------------+-------------+------+-----+---------+-------+
  10.    
  11. sqoop import
  12.   --connect "jdbc:mysql://quickstart.cloudera:3306/retail_db"
  13.   --username=root
  14.   --password=cloudera
  15.   --table orders
  16.   --target-dir /user/hive/warehouse/retail_stage.db/orders
  17.   --as-avrodatafile
  18.   --split-by order_id
  19.    
  20. hive> describe orders;
  21. OK
  22. error_error_error_error_error_error_error   string                  from deserializer  
  23. cannot_determine_schema string                  from deserializer  
  24. check                   string                  from deserializer  
  25. schema                  string                  from deserializer  
  26. url                     string                  from deserializer  
  27. and                     string                  from deserializer  
  28. literal                 string                  from deserializer  
  29. Time taken: 1.15 seconds, Fetched: 7 row(s)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top