Yahoo Web Search

Search results

1. Top results related to hive cast as string

   • Hive SQL cast string as timestamp without losing the milliseconds

     Top Answer

     Answered Feb 02, 2021 · 1 votes

     Tested in Hive 2.3.6 on Qubole and on demo.gethue.com, works good:

     select cast ('2020-10-21 12:49:27.090' as timestamp), timestamp('2020-10-21 12:49:27.090')-

     Result:

     2020-10-21 12:49:27.09 2020-10-21 12:49:27.09-

     And this

     cast(date_format('2020-10-21 12:49:27.090','yyyy-MM-dd HH:mm:ss.SSS') as timestamp)

     also works the same.

     It seems like some problem with your client applpication or Hive version

     Check all answers on Stack Overflow

     1/5

   • Hive cast string to date dd-MM-yyyy

     Top Answer

     Answered Jul 25, 2016 · 64 votes

     try:

     from_unixtime(unix_timestamp('12-03-2010' , 'dd-MM-yyyy'))-

     Check all answers on Stack Overflow

     2/5

   • Cast string to date in hive

     Top Answer

     Answered Apr 16, 2021 · 0 votes

     You can try below

     select to_date(from_unixtime(to_unix_timestamp('3/10/21 18:46','dd/MM/yy HH:mm'),'yyyy-MM-dd HH:mm:ss'));-

     Snippet

     Check all answers on Stack Overflow

     3/5

   • Hive - How to cast array to string?

     Top Answer

     Answered Sep 24, 2018 · 2 votes

     explode function Explodes an array to multiple rows. Returns a row-set with a single column (col), one row for each element from the array.

     you would need concat_ws function to concatenate comma separated array values to String.

     function: concat_ws(string SEP, array)

     Refer to: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF

     SELECT email_address, concat_ws(',', GP_array) AS GP FROM dm.TP

     concat_ws will return the comma separated String constructed from Array values.

     Check all answers on Stack Overflow

     4/5

   • Hive Create table - When to use VARCHAR and STRING as column data type

     Top Answer

     Answered May 12, 2017 · 2 votes

     VARCHAR was introduced in Hive 0.12.0 for more SQL-compliant behavior, such as SQL string comparison semantics, max length, etc (See HIVE-4844).

     Varchar types are created with a length specifier (between 1 and 65355), which defines the maximum number of characters allowed in the character string. If a string value being converted/assigned to a varchar value exceeds the length specifier, the string is silently truncated. Also there is a limitation: Non-generic UDFs cannot directly use varchar type as input arguments or return values. See here:wiki

     STRING has no such limitation. The max length of a STRING is 2GB

     Check all answers on Stack Overflow

     5/5

   Show moreShow less

2. sparkbyexamples.com › apache-hive › hive-castHive Cast Function to Convert Data Type - Spark By {Examples}

   sparkbyexamples.com › apache-hive › hive-cast

   • Cached

   Feb 7, 2023 · Hive CAST(from_datatype as to_datatype) function is used to convert from one data type to another for example to cast String to Integer (int), String to Bigint, String to Decimal, Decimal to Int data types, and many more. This cast () function is referred to as the type conversion function which is used to convert data types in Hive. In this ...

3. stackoverflow.com › questions › 32475465Hive cast string to date dd-MM-yyyy - Stack Overflow

   stackoverflow.com › questions › 32475465

   • Cached

   Dec 3, 2010 · 4. Let's say you have a column 'birth_day' in your table which is in string format, you should use the following query to filter using birth_day. date_Format(birth_day, 'yyyy-MM-dd') You can use it in a query in the following way. select * from yourtable. where. date_Format(birth_day, 'yyyy-MM-dd') = '2019-04-16';

   Usage example

   from_unixtime(unix_timestamp('12-03-2010' , 'dd-MM-yyyy'))

   See more on stackoverflow

4. People also ask

   What is hive cast() function?

   • Hive CAST(from_datatype as to_datatype) function is used to convert from one data type to another for example to cast String to Integer (int), String to Bigint, String to Decimal, Decimal to Int data types, and many more. This cast () function is referred to as the type conversion function which is used to convert data types in Hive.

   Hive Cast Function to Convert Data Type - Spark By {Examples}

   sparkbyexamples.com/apache-hive/hive-cast-function-to-convert-data-type/

   See all results for this question

   What are Hive string functions?

   • These Hive string functions come in handy when you are doing transformations without bringing data into Spark and using String functions or any equivalent frameworks. In this article let’s learn the most used String Functions syntax, usage, description along with examples.

   Hive Built-in String Functions with Examples

   sparkbyexamples.com/apache-hive/hive-built-in-string-functions-with-examples/

   See all results for this question

   What are hive type conversion functions?

   • Hive type conversion functions are used to explicitly convert to the required type and format. For example, Hive does not convert DOUBLE to FLOAT, INT to STRING etc. In my other post, we have discussed on Hive date functions and examples. In this article, we will check out Cloudera Hive type conversion functions with some examples. Related Article

   Apache Hive Type Conversion Functions and Examples

   dwgeek.com/apache-hive-type-conversion-functions-and-examples.html/

   See all results for this question

   What functions does Hive have?

   • Hive has its own functions, I have written some examples for the sake of illustration of these date- and cast- functions: Date and timestamp functions examples: Convert String/Timestamp/Date to DATE Convert String/Timestamp/Date to BIGINT_TYPE Convert String/Timestamp/Date to STRING Convert BIGINT unixtime to STRING

   Hive cast string to date dd-MM-yyyy - Stack Overflow

   stackoverflow.com/questions/32475465/hive-cast-string-to-date-dd-mm-yyyy

   See all results for this question

5. dwgeek.com › apache-hive-type-conversion-functionsApache Hive Type Conversion Functions and Examples

   dwgeek.com › apache-hive-type-conversion-functions

   • Cached

   Sep 30, 2019 · Hive CAST function converts the value of an expression to any other type. The result of the function will be NULL in case if function cannot converts to particular data type. You can use this function when passing a column value or literal to a function that expects a parameter with a different data type. CAST (<from-type> AS <to-type>);

6. bigdatansql.com › 16 › cast-function-in-apache-hiveCAST Function in Apache Hive – Big Data & SQL

   bigdatansql.com › 16 › cast-function-in-apache-hive

   The Apache Hive CAST function is a type conversion function that converts data types from one to another. It can convert a string to an integer, an integer to a decimal, a string to a date, and a date to a timestamp, among other things. For a better understanding, look at the examples below. Test Data: SELECT * FROM testdate; Result: Date1 Date2.

7. bigdatansql.com › 2021/02/24 › type-conversionType Conversion Functions in Apache Hive – Big Data & SQL

   bigdatansql.com › 2021/02/24 › type-conversion

   One of the commonly used functions in RDBMS is the CAST function, which helps to transform the expression of one data type to another data type. It’s also available in Apache Hive and Apache Impala. The below are the scenarios when we use CAST function. 1) If the date information has to be converted to a string.

8. cwiki.apache.org › confluence › displayHive Data Types - The Apache Software Foundation

   cwiki.apache.org › confluence › display

   • Cached

   Aug 31, 2021 · Hive 0.11 and 0.12 have the precision of the DECIMAL type fixed and limited to 38 digits. As of Hive 0.13 users can specify scale and precision when creating tables with the DECIMAL datatype using a DECIMAL(precision, scale) syntax. If scale is not specified, it defaults to 0 (no fractional digits).