Hiveql

Discussion List

• 
  Convert a function into HIVE QL format?

  Anurag 26 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  How do we get the current system date in Hive?

  Anurag 22 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  How can I have a column in Hive be defined as a subquery? Is this possible in Hive?

  Anurag 12 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  How do I write out an array literal in Hive?

  Anurag 38 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Select Statement is not giving desired result.

  Anurag 13 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Casting a String Column to 2 Digit scale in Hive Query Language.

  Anurag 24 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Hiveql subquery is not working.

  Anurag 52 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  How to display the day of a previous date?

  Anurag 21 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  How to get data from 2 tables on monthly basis?

  Anurag 11 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Creating a Hive table using “CASE WHEN”

  Anurag 11 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  How can i insert an array of 500 names in a Hive table having a Column of type array.

  Anurag 2 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Creating a table with different structure from an existing table.

  Anurag 11 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Use of Concat() in Hive.

  Anurag 11 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Is there a way to find out the root directory, under which a particular directory was created.

  Anurag 14 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  How to write Hiveql to select a column between current date and 3 years back.

  Anurag 14 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Insert data to partition table .

  Anurag 18 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Convert date format.

  Anurag 17 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Calculate the days difference and populate a new column in target table.

  Anurag 9 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Get the latest record from a table based on some columns and insert in another table in hive.

  Anurag 9 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Use of Inner joins in Hive Query.

  Anurag 51 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Is there an equivalent to the Contains function in SAS Hadoop?

  Anurag 11 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Insert some values into a table with partitions based on a column.

  Anurag 40 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Generate a select query in a way that i can select 5 columns and assign a unique row.

  Anurag 14 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Pass a filter parameter to view in hive so that it is applied to the table as well.

  Anurag 17 views 0 comments 0 points Started by Anurag January 2019 Hive
• 
  Hive query to find out the time gap between two value of same column.

  Anurag 15 views 0 comments 0 points Started by Anurag January 2019 Hive