Josh Mahonin created PHOENIX-2784: ------------------------------------- Summary: phoenix-spark: Allow coercion of DATE fields to TIMESTAMP when loading DataFrames Key: PHOENIX-2784 URL: https://issues.apache.org/jira/browse/PHOENIX-2784 Project: Phoenix Issue Type: Improvement Affects Versions: 4.7.0 Reporter: Josh Mahonin Assignee: Josh Mahonin Priority: Minor
The Phoenix DATE type is internally represented as an 8 bytes, which can store a full 'yyyy-MM-dd hh:mm:ss' time component. However, Spark SQL follows the SQL Date spec and keeps only the 'yyyy-MM-dd' portion as a 4 byte type. When loading Phoenix DATE columns using the Spark DataFrame API, the 'hh:mm:ss' component is lost. This patch allows setting a new 'dateAsTimestamp' option when loading a DataFrame, which will coerce the underlying Date object to a Timestamp so that the full time component is loaded. -- This message was sent by Atlassian JIRA (v6.3.4#6332)