Packages

o

com.datasolvr.services.facade

BuiltInFunctions

object BuiltInFunctions

The SQL functions that are available as standard in addition to ones included in Apache Spark.

Linear Supertypes
AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. BuiltInFunctions
  2. AnyRef
  3. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Value Members

  1. final def !=(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  4. def all: List[String]
  5. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  6. val bucket: String

    Rounds a double to given bucket size.

    Rounds a double to given bucket size.

    Example:
    1. ds_bucket(7.0, 2.5) = 5.0

  7. def clone(): AnyRef
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... ) @native() @HotSpotIntrinsicCandidate()
  8. val danishMunicipality: String

    Gets an array of weighted pairs of municipalities for a Danish postal code.

    Gets an array of weighted pairs of municipalities for a Danish postal code.

    Examples:
    1. ds_danish_municipality('2600') = [('Glostrup', 0.5), ('Albertslund', 0.5)].

    2. ,
    3. ds_danish_municipality('2605') = [('Brøndby', 1.0)].

  9. val danishPostalCodeId: String

    Gets a group identifier for a Danish postal code given a postal code text.

    Gets a group identifier for a Danish postal code given a postal code text.

    Examples:
    1. ds_danish_postal_code_id('1620') = '1500-1799'.

    2. ,
    3. ds_danish_postal_code_id('2200') = '2200'.

  10. val danishRegion: String

    Gets the region for a Danish municipality.

    Gets the region for a Danish municipality.

    Example:
    1. ds_danish_region('Albertslund') = 'Hovedstaden'.

  11. val dayOfWeekSorted: String

    For internal use only.

  12. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  13. def equals(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  14. final def getClass(): Class[_]
    Definition Classes
    AnyRef → Any
    Annotations
    @native() @HotSpotIntrinsicCandidate()
  15. def hashCode(): Int
    Definition Classes
    AnyRef → Any
    Annotations
    @native() @HotSpotIntrinsicCandidate()
  16. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  17. val monthOfYearSorted: String

    For internal use only.

  18. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  19. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native() @HotSpotIntrinsicCandidate()
  20. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native() @HotSpotIntrinsicCandidate()
  21. val quarterOfYear: String

    Gets the quarter of the year for a given date.

    Gets the quarter of the year for a given date.

    Example:
    1. ds_quarter_of_year(2021-07-02) = 'Q3'.

  22. val roundToMonth: String

    Gets the year and month part of a the given date.

    Gets the year and month part of a the given date.

    Example:
    1. ds_round_to_month(2021-07-02) = '2021-07'.

  23. val roundToQuarter: String

    Gets the year and quarter part of a the given date.

    Gets the year and quarter part of a the given date.

    Example:
    1. ds_round_to_month(2021-07-02) = '2021-Q3'.

  24. val roundToWeek: String

    Gets the date of the monday in the same week a the given date.

    Gets the date of the monday in the same week a the given date.

    Example:
    1. ds_round_to_week(2021-07-02) = 2021-06-28.

  25. final def synchronized[T0](arg0: ⇒ T0): T0
    Definition Classes
    AnyRef
  26. val textToWords: String

    Gets the array of words in a given text removing Danish and English stop words.

    Gets the array of words in a given text removing Danish and English stop words.

    Example:
    1. ds_text_to_words('This is an amazing sentence') = [amazing, sentence].

  27. val timelineDate: String

    Gets the date and time used when loading data sets.

    Gets the date and time used when loading data sets.

    Example:
    1. ds_get_timeline_date() = 2021-07-02 00:00:00 when used in a pipeline run with this date and time.

  28. def toString(): String
    Definition Classes
    AnyRef → Any
  29. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  30. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... ) @native()
  31. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

Deprecated Value Members

  1. def finalize(): Unit
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] ) @Deprecated
    Deprecated

Inherited from AnyRef

Inherited from Any

Ungrouped