hive 84

  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 to know Hive and Hadoop versions from command prompt?
  8. How to set variables in HIVE scripts
  9. Where does Hive store files in HDFS?
  10. Parquet vs ORC vs ORC with Snappy
  11. How does Hive compare to HBase?
  12. How to get/generate the create statement for an existing hive table?
  13. Is there any way to get the column name along with the output while execute any query in Hive?
  14. How to select current date in Hive SQL
  15. How does impala provide faster query response compared to hive
  16. How to delete and update a record in Hive
  17. Hive cluster by vs order by vs sort by
  18. Hive insert query like SQL
  19. What is Hive: Return Code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
  20. Hive: how to show all partitions of a table?
  21. How to export a Hive table into a CSV file?
  22. How to load data to hive from HDFS without removing the source file?
  23. What is the difference between Apache Spark SQLContext vs HiveContext?
  24. How to save DataFrame directly to Hive?

  25. Hive load CSV with commas in quoted fields
  26. Hive: Convert String to Integer
  27. Explode the Array of Struct in Hive
  28. COLLECT_SET() in Hive, keep duplicates?
  29. Does Hive have a String split function?
  30. I have created a table in hive, I would like to know which directory my table is created in?
  31. Loading Data from a .txt file to Table Stored as ORC in Hive
  32. Hive installation issues: Hive metastore database is not initialized
  33. What's the difference between -DskipTests and -Dmaven.test.skip=true
  34. How to Access Hive via Python?
  35. How to convert .txt file to Hadoop's sequence file format
  36. java.lang.RuntimeException:Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
  37. Just get column names from hive table
  38. Hive query output to file
  39. How do you make a HIVE table out of JSON data?
  40. Hive: writing column headers to local file?
  41. Is there a way to make a multi line comment in hive scripts
  42. Hive query to quickly find table size (number of rows)
  43. Can OLAP be done in BigTable?
  44. Hadoop/Hive : Loading data from .csv on a local machine
  45. Querying on multiple Hive stores using Apache Spark
  46. Books to start learning big data
  47. How do I copy files from S3 to Amazon EMR HDFS?
  48. How to load a text file into a Hive table stored as sequence files
  49. hive sql find the latest record
  50. Unable to use an existing Hive permanent UDF from Spark SQL