Class: Row

eclairjs/sql. Row

Represents one row of output from a relational operator. Allows both generic access by ordinal, which will incur boxing overhead for primitives, as well as native primitive access. It is invalid to use the native primitive interface to retrieve a value that is null, instead a user must check isNullAt before attempting to retrieve a value that might be null. To create a new Row, use RowFactory.create()

Constructor

new Row()

Source:

Methods

anyNull() → {boolean}

Returns true if there are any NULL values in this row.
Source:
Returns:
Type
boolean

apply(index) → {object}

Returns the value at position index.
Parameters:
Name Type Description
index
Source:
Returns:
Type
object

copy() → {module:eclairjs/sql.Row}

Make a copy of the current Row object
Source:
Returns:
Type
module:eclairjs/sql.Row

equals(o) → {boolean}

compares object o to this Row object
Parameters:
Name Type Description
o object
Source:
Returns:
Type
boolean

fieldIndex(name) → {integer}

Returns the index of a given field name.
Parameters:
Name Type Description
name string
Source:
Returns:
Type
integer

get(index) → {object}

Returns the value at position index.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
object

getArray(index) → {Array.<Object>}

Returns the value at position i of array type as array.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
Array.<Object>

getAs(fieldName) → {integer|String|float}

Returns the value of a given fieldName.
Parameters:
Name Type Description
fieldName String
Source:
Returns:
Type
integer | String | float

getBinary(index) → {Array.<int>}

Returns the value at position index, representing Array[Byte] values.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
Array.<int>
Example
var fields = [];
fields.push(DataTypes.createStructField("key", DataTypes.IntegerType, true));
fields.push(DataTypes.createStructField("value", DataTypes.BinaryType, true));
var schema = DataTypes.createStructType(fields);
var df = sqlContext.createDataFrame([[1,[16,5,6]], [2,[12, 14, 9]]], schema);
df.show();
var results = df.toRDD().map(function(row) {
 	return "key: " + row.getInt(0) + " value: " + row.getBinary(1);
});

getBoolean(index) → {boolean}

Returns the value at position index as a primitive boolean.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
boolean

getDate(index) → {module:eclairjs/sql.SqlDate}

Returns the value at position index of type as Date.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
module:eclairjs/sql.SqlDate

getDouble(index) → {float}

Returns the value at position index of type as javascript float.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
float

getFloat(index) → {float}

Returns the value at position index of type as float.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
float

getInt(index) → {integer}

Returns the value at position index of type as integer.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
integer

getList(index) → {Array.<Object>}

Returns the value at position i of array type as array.
Parameters:
Name Type Description
index integer
Deprecated:
Source:
Returns:
Type
Array.<Object>

getString(index) → {String}

Returns the value at position index of type as String.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
String

getStruct(index) → {String}

Returns the value at position index of struct type as an Row object.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
String

getTimestamp(index) → {module:eclairjs/sql.SqlTimestamp}

Returns the value at position index of Timestamp type as Date.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
module:eclairjs/sql.SqlTimestamp

hashCode() → {int}

Returns hash code
Source:
Returns:
Type
int

isNullAt(index) → {boolean}

Checks whether the value at position index is null.
Parameters:
Name Type Description
index integer
Source:
Returns:
Type
boolean

length() → {integer}

Number of elements in the Row.
Source:
Returns:
Type
integer

mkString(separatoropt, startopt, endopt) → {string}

Displays all elements of this traversable or iterator in a string using start, end, and separator strings.
Parameters:
Name Type Attributes Description
separator string <optional>
start string <optional>
 start will be ignored if end parameter is not specified
end string <optional>
 Required if start specified
Source:
Returns:
Type
string

schema() → {module:eclairjs/sql/types.StructType}

Schema for the row.
Source:
Returns:
Type
module:eclairjs/sql/types.StructType

size() → {integer}

Number of elements in the Row.
Source:
Returns:
Type
integer