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

# · text · 49 lines · 49 code · 0 blank · 0 comment · 0 complexity · 19c081e3b666622fc64331c71c8adf70 MD5 · raw file 

    

  1. PREHOOK: query: create table exim_department ( dep_id int comment "department id") 	
    2. 

  2. 	stored as textfile	
    3. 

  3. 	tblproperties("creator"="krishna")
    4. 

  4. PREHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: query: create table exim_department ( dep_id int comment "department id") 	
    6. 

  6. 	stored as textfile	
    7. 

  7. 	tblproperties("creator"="krishna")
    8. 

  8. POSTHOOK: type: CREATETABLE
    9. 

  9. POSTHOOK: Output: default@exim_department
    10. 

  10. PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
    11. 

  11. PREHOOK: type: LOAD
    12. 

  12. PREHOOK: Output: default@exim_department
    13. 

  13. POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
    14. 

  14. POSTHOOK: type: LOAD
    15. 

  15. POSTHOOK: Output: default@exim_department
    16. 

  16. PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
    17. 

  17. PREHOOK: type: EXPORT
    18. 

  18. PREHOOK: Input: default@exim_department
    19. 

  19. PREHOOK: Output: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/exports/exim_department
    20. 

  20. POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
    21. 

  21. POSTHOOK: type: EXPORT
    22. 

  22. POSTHOOK: Input: default@exim_department
    23. 

  23. POSTHOOK: Output: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/exports/exim_department
    24. 

  24. PREHOOK: query: drop table exim_department
    25. 

  25. PREHOOK: type: DROPTABLE
    26. 

  26. PREHOOK: Input: default@exim_department
    27. 

  27. PREHOOK: Output: default@exim_department
    28. 

  28. POSTHOOK: query: drop table exim_department
    29. 

  29. POSTHOOK: type: DROPTABLE
    30. 

  30. POSTHOOK: Input: default@exim_department
    31. 

  31. POSTHOOK: Output: default@exim_department
    32. 

  32. PREHOOK: query: create database importer
    33. 

  33. PREHOOK: type: CREATEDATABASE
    34. 

  34. POSTHOOK: query: create database importer
    35. 

  35. POSTHOOK: type: CREATEDATABASE
    36. 

  36. PREHOOK: query: use importer
    37. 

  37. PREHOOK: type: SWITCHDATABASE
    38. 

  38. POSTHOOK: query: use importer
    39. 

  39. POSTHOOK: type: SWITCHDATABASE
    40. 

  40. PREHOOK: query: create table exim_department ( dep_id bigint comment "department id") 	
    41. 

  41. 	stored as textfile	
    42. 

  42. 	tblproperties("creator"="krishna")
    43. 

  43. PREHOOK: type: CREATETABLE
    44. 

  44. POSTHOOK: query: create table exim_department ( dep_id bigint comment "department id") 	
    45. 

  45. 	stored as textfile	
    46. 

  46. 	tblproperties("creator"="krishna")
    47. 

  47. POSTHOOK: type: CREATETABLE
    48. 

  48. POSTHOOK: Output: importer@exim_department
    49. 

  49. FAILED: Error in semantic analysis: The existing table is not compatible with the import spec.   Column Schema does not match
    50.