Advertisement
Guest User

Impala Parquet/stats issue

a guest
Oct 18th, 2014
277
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. [hostname:21000] > create table pqtest2 (id string) stored as parquet;
  2. Query: create table pqtest2 (id string) stored as parquet
  3.  
  4. Fetched 0 row(s) in 0.17s
  5. [hostname:21000] > insert into pqtest2 values 'a';
  6. Query: insert into pqtest2 values 'a'
  7. ERROR: AnalysisException: Syntax error in line 1:
  8. insert into pqtest2 values 'a'
  9. ^
  10. Encountered: STRING LITERAL
  11. Expected: (
  12.  
  13. CAUSED BY: Exception: Syntax error
  14. [hostname:21000] > insert into pqtest2 values ('a');
  15. Query: insert into pqtest2 values ('a')
  16. Inserted 1 row(s) in 1.31s
  17. [hostname:21000] > insert into pqtest2 values ('b');
  18. Query: insert into pqtest2 values ('b')
  19. Inserted 1 row(s) in 0.22s
  20. [hostname:21000] > select * from pqtest2;
  21. Query: select * from pqtest2
  22. +----+
  23. | id |
  24. +----+
  25. | a |
  26. | b |
  27. +----+
  28. Fetched 2 row(s) in 0.20s
  29. [hostname:21000] > compute stats pqtest2;
  30. Query: compute stats pqtest2
  31. +-----------------------------------------+
  32. | summary |
  33. +-----------------------------------------+
  34. | Updated 1 partition(s) and 1 column(s). |
  35. +-----------------------------------------+
  36. Fetched 1 row(s) in 1.21s
  37. [hostname:21000] > describe pqtest2;
  38. Query: describe pqtest2
  39. ERROR: AnalysisException: Failed to load metadata for table: default.pqtest2
  40. CAUSED BY: TableLoadingException: Failed to load metadata for table: pqtest2
  41. CAUSED BY: TTransportException: null
  42. [hostname:21000] > show create table pqtest2;
  43. Query: show create table pqtest2
  44. ERROR: AnalysisException: Failed to load metadata for table: default.pqtest2
  45. CAUSED BY: TableLoadingException: Failed to load metadata for table: pqtest2
  46. CAUSED BY: TTransportException: null
  47. [hostname:21000] > drop table pqtest2;
  48. Query: drop table pqtest2
  49. ERROR: AnalysisException: Failed to load metadata for table: default.pqtest2
  50. CAUSED BY: TableLoadingException: Fail
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement