hive 204

  1. Difference between Pig and Hive? Why have both?
  2. When to use Hadoop, HBase, Hive and Pig?
  3. What is the difference between partitioning and bucketing a table in Hive ?
  4. Difference between Hive internal tables and external tables?
  5. Integration testing Hive jobs
  6. How do I output the results of a HiveQL query to CSV?
  7. How does Hive compare to HBase?
  8. How to set variables in HIVE scripts
  9. How to know Hive and Hadoop versions from command prompt?
  10. How to get/generate the create statement for an existing hive table?
  11. Is there any way to get the column name along with the output while execute any query in Hive?
  12. How does impala provide faster query response compared to hive
  13. How to delete and update a record in Hive
  14. How to convert .txt file to Hadoop's sequence file format
  15. Explode the Array of Struct in Hive
  16. How to Update/Drop a Hive Partition?
  17. Books to start learning big data
  18. How to load a text file into a Hive table stored as sequence files
  19. Querying on multiple Hive stores using Apache Spark
  20. I have created a table in hive, I would like to know which directory my table is created in?
  21. Hive query output to file
  22. Hive unable to manually set number of reducers
  23. SQL split comma separated row
  24. Create hive table using “as select” or “like” and also specify delimiter
  25. Pig vs Hive vs Native Map Reduce
  26. Transferring hive table from one database to another
  27. Error happening while using json_tuple syntax in hive script
  28. Spark final task takes 100x times longer than first 199, how to improve
  29. Hive External table-CSV File- Header row
  30. Connect from Java to Hive using JDBC
  31. Add a column in a table in HIVE QL
  32. In a hadoop cluster, should hive be installed on all nodes?
  33. Combine multiple rows into one space separated string
  34. What does the hive metastore and name node do in a cluster?
  35. Parse json arrays using HIVE
  36. Loading data with Hive, S3, EMR, and Recover Partitions
  37. how to design Hbase schema?
  38. Add PARTITION after creating TABLE in hive
  39. `EMR service role is invalid` when Creating EMR Cluster
  40. Access Hive Data Using Python
  41. Hive RegexSerDe Multiline Log matching
  42. Hive Select Into
  43. Hive Query- Joining two tables on three joining conditions with OR operator
  44. Hadoop on cassandra database
  45. Generating star schema in hive
  46. Grouping hive rows in an array of this rows
  47. python cannot connect hiveserver2
  48. Does varchar perform better than string in Hive?
  49. Why can't hive recognize alias named in select part?
  50. How to pick up all data into hive from subdirectories