q08_reviewed_sales_sum, q08_all_sales_sum = client.compute(
[q08_reviewed_sales_sum, q08_all_sales_sum])
q08_reviewed_sales_sum, q08_all_sales_sum = (
q08_reviewed_sales_sum.result(),
q08_all_sales_sum.result(),
)
no_q08_review_sales_amount = q08_all_sales_sum - q08_reviewed_sales_sum
final_result_df = cudf.DataFrame()
final_result_df["q08_review_sales_amount"] = [q08_reviewed_sales_sum]
final_result_df["q08_review_sales_amount"] = final_result_df[
"q08_review_sales_amount"].astype("int")
final_result_df["no_q08_review_sales_amount"] = [
no_q08_review_sales_amount
]
final_result_df["no_q08_review_sales_amount"] = final_result_df[
"no_q08_review_sales_amount"].astype("int")
return final_result_df
if __name__ == "__main__":
from xbb_tools.cluster_startup import attach_to_cluster
import cudf
import dask_cudf
config = tpcxbb_argparser()
client, bc = attach_to_cluster(config)
run_query(config=config, client=client, query_func=main)
'NEG' AS sentiment
FROM word_df wd
INNER JOIN negativeSentiment n ON wd.word = n.word
), word_sentence_sentiment_with_sentence_info AS
(
SELECT * FROM word_sentence_sentiment
LEFT JOIN sentences_table
ON sentence_idx_global_pos = sentence_tokenized_global_pos
)
SELECT tt2.store_ID AS s_name,
tt2.pr_review_date AS r_date,
wsswsi.sentence AS r_sentence,
wsswsi.sentiment AS sentiment,
wsswsi.word AS sentiment_word
FROM word_sentence_sentiment_with_sentence_info wsswsi
INNER JOIN temp_table2 tt2
ON wsswsi.review_idx_global_pos = tt2.pr_review_sk
ORDER BY s_name, r_date, r_sentence, sentiment_word
"""
result = bc.sql(query_4)
return result
if __name__ == "__main__":
config = tpcxbb_argparser()
client, bc = attach_to_cluster(config, create_blazing_context=True)
run_query(config=config,
client=client,
query_func=main,
blazing_context=bc)
