PageRenderTime 37ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientnegative/exim_24_import_part_authfail.q.out

#
text | 60 lines | 60 code | 0 blank | 0 comment | 0 complexity | 490ba30b4eefe6a131906697b0b27bd3 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: create table exim_employee ( emp_id int comment "employee id") 	
    2. 

  2. 	comment "employee table"
    3. 

  3. 	partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
    4. 

  4. 	stored as textfile	
    5. 

  5. 	tblproperties("creator"="krishna")
    6. 

  6. PREHOOK: type: CREATETABLE
    7. 

  7. POSTHOOK: query: create table exim_employee ( emp_id int comment "employee id") 	
    8. 

  8. 	comment "employee table"
    9. 

  9. 	partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
    10. 

  10. 	stored as textfile	
    11. 

  11. 	tblproperties("creator"="krishna")
    12. 

  12. POSTHOOK: type: CREATETABLE
    13. 

  13. POSTHOOK: Output: default@exim_employee
    14. 

  14. PREHOOK: query: load data local inpath "../data/files/test.dat" 
    15. 

  15. 	into table exim_employee partition (emp_country="in", emp_state="tn")
    16. 

  16. PREHOOK: type: LOAD
    17. 

  17. PREHOOK: Output: default@exim_employee
    18. 

  18. POSTHOOK: query: load data local inpath "../data/files/test.dat" 
    19. 

  19. 	into table exim_employee partition (emp_country="in", emp_state="tn")
    20. 

  20. POSTHOOK: type: LOAD
    21. 

  21. POSTHOOK: Output: default@exim_employee
    22. 

  22. POSTHOOK: Output: default@exim_employee@emp_country=in/emp_state=tn
    23. 

  23. PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
    24. 

  24. PREHOOK: type: EXPORT
    25. 

  25. PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
    26. 

  26. PREHOOK: Output: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/exports/exim_employee
    27. 

  27. POSTHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
    28. 

  28. POSTHOOK: type: EXPORT
    29. 

  29. POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
    30. 

  30. POSTHOOK: Output: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/exports/exim_employee
    31. 

  31. PREHOOK: query: drop table exim_employee
    32. 

  32. PREHOOK: type: DROPTABLE
    33. 

  33. PREHOOK: Input: default@exim_employee
    34. 

  34. PREHOOK: Output: default@exim_employee
    35. 

  35. POSTHOOK: query: drop table exim_employee
    36. 

  36. POSTHOOK: type: DROPTABLE
    37. 

  37. POSTHOOK: Input: default@exim_employee
    38. 

  38. POSTHOOK: Output: default@exim_employee
    39. 

  39. PREHOOK: query: create database importer
    40. 

  40. PREHOOK: type: CREATEDATABASE
    41. 

  41. POSTHOOK: query: create database importer
    42. 

  42. POSTHOOK: type: CREATEDATABASE
    43. 

  43. PREHOOK: query: use importer
    44. 

  44. PREHOOK: type: SWITCHDATABASE
    45. 

  45. POSTHOOK: query: use importer
    46. 

  46. POSTHOOK: type: SWITCHDATABASE
    47. 

  47. PREHOOK: query: create table exim_employee ( emp_id int comment "employee id") 	
    48. 

  48. 	comment "employee table"
    49. 

  49. 	partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
    50. 

  50. 	stored as textfile	
    51. 

  51. 	tblproperties("creator"="krishna")
    52. 

  52. PREHOOK: type: CREATETABLE
    53. 

  53. POSTHOOK: query: create table exim_employee ( emp_id int comment "employee id") 	
    54. 

  54. 	comment "employee table"
    55. 

  55. 	partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
    56. 

  56. 	stored as textfile	
    57. 

  57. 	tblproperties("creator"="krishna")
    58. 

  58. POSTHOOK: type: CREATETABLE
    59. 

  59. POSTHOOK: Output: importer@exim_employee
    60. 

  60. Authorization failed:No privilege 'Alter' found for outputs { database:importer, table:exim_employee}. Use show grant to get more details.
    61. 

  61.